Failure to result in a blank field - PLEASE HELP

Hey Guys,
I’ve had this issue before, and was able to solve it.
For some reason, it doesn’t work now.

We’re betting on score difference, so:

IF({Home Score}>{Away Score},{Home Score}-{Away Score},{Away Score}-{Home Score})

If the game hasn’t played yet, the {Home Score} & {Away Score} are empty, which results in ‘0’
So, I’ve tried checking if the records are empty or not.

IF(AND({Home Score},{Away Score}), IF({Home Score}>{Away Score},{Home Score}-{Away Score},{Away Score}-{Home Score})

But I keep getting an error, that my syntax is wrong.

After the above I’m running this:

IF({Points Difference Bet}={Actual Points Difference},“Bingo!”,IF({Actual Points Difference}-{Points Difference Bet}<=5,“Very Close”, “Way Off”))

But the points difference can actually be higher than 5, but I’d still get “Very Close”

Please help.

Thank you.

Guys, I’d really appreciate some help.
Thanks.

You’re just missing a closing bracket for the outer IF statement. This works:

IF(
  AND({Home Score}, {Away Score}), 
  IF(
    {Home Score}>{Away Score},
    {Home Score}-{Away Score},
    {Away Score}-{Home Score}
  )
)

JB

Yep, figured it out myself :slight_smile: thanks anyway.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.