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.