Nested IF Statement not recognizing $0.00

Question

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 fieldThe 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 Answer

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}
))

This worked. Thank you so much!

ta2530 · Answer

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}
))

This worked. Thank you so much!

Nested IF Statement not recognizing $0.00

1 Attachments

2 replies

1 Attachments

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded