Solved
678 0
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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”

Thank you.

1 Solution

Accepted Solutions
13 - Mars

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

3 Replies 3
6 - Interface Innovator

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

13 - Mars

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

6 - Interface Innovator

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