Help

Trouble with nested IF formulas

6255 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Katie_Hayes
4 - Data Explorer
4 - Data Explorer

I am trying to create an event expense tracking table. In one column, I want to know if an event is on or over budget. I have a column, “Total”, where I will record the amount the event cost. Ideally I would then like the next column to be populated with whether it was on or over budget.

I am trying to write a formula where Total under 1500 populates the formula column with “On Budget”, Total over 1500 populates the formula column with “Over Budget”, and Total that is blank leaves the formula column blank. This is what I have written:

IF(Total<1500, “On Budget”, “Over Budget”), IF(Total=BLANK, BLANK)

But an error pops up that reads, “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.” What am I doing wrong?

10 Replies 10
Jozsef_Kurucity
4 - Data Explorer
4 - Data Explorer

Hi,
I have a question about nested IF formulas. Would Airtable handle more than 70 nested IF formulas?