Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Failure to result in a blank field - PLEASE HELP

Topic Labels: Formulas
Solved
Jump to Solution
495 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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 :slightly_smiling_face: thanks anyway.