Help

Re: Failure to result in a blank field - PLEASE HELP

Solved
Jump to Solution
1244 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Omer_Nesher
6 - Interface Innovator
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”

Please help.

Thank you.

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
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

See Solution in Thread

3 Replies 3
Omer_Nesher
6 - Interface Innovator
6 - Interface Innovator

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

JonathanBowen
13 - Mars
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

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