Help

Nested IF Statement not recognizing $0.00

Topic Labels: Data Formulas
Solved
Jump to Solution
210 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ta2530
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone,

I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed: 

 
My formula:
 
IF({August FY25 Projections},{August FY25 Projections},IF({FY Start Split Formula},{FY Start Split Formula},{Original FY25 Revenue Projections}))
 
For reference:
The August FY25 Projections column is a currency field
The other 2 fields are formulated fields with a currency format.
Attached you can see the "Updated FY25 Revenue Projections" column is skipping over the $0.00 amount that is listed in the August field. This is incorrect and should have picked up the $0.00 amount as per the order of the IF statement.
 
Any help would be appreciated!
 
1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

In Airtable formulas, a numeric value of zero is a "falsy" value, and thus you cannot check for the presence of a value in a numeric field with only the field name. Instead, convert the value to a text string to test if there is a value.

IF(
  {August FY25 Projections} & "",
  {August FY25 Projections},
IF(
  {FY Start Split Formula} & "",
  {FY Start Split Formula},
  {Original FY25 Revenue Projections}
))

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

In Airtable formulas, a numeric value of zero is a "falsy" value, and thus you cannot check for the presence of a value in a numeric field with only the field name. Instead, convert the value to a text string to test if there is a value.

IF(
  {August FY25 Projections} & "",
  {August FY25 Projections},
IF(
  {FY Start Split Formula} & "",
  {FY Start Split Formula},
  {Original FY25 Revenue Projections}
))
ta2530
5 - Automation Enthusiast
5 - Automation Enthusiast

This worked. Thank you so much!