Failure to result in a blank field - PLEASE HELP

[Omer_Nesher]

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.

[Omer_Nesher]

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

[JonathanBowen · Accepted solution]

Omer_Nesher:

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

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

[Omer_Nesher]

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