Nested IF Statement not recognizing $0.00

[ta2530]

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!

[kuovonne · Accepted solution]

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]

This worked. Thank you so much!