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

Trouble using nested IF formula with AND function

Topic Labels: Formulas
293 2
Showing results for 
Search instead for 
Did you mean: 

I keep receiving an invalid error when trying write this formula:

IF({Close ID} != “”, "imported”, IF(AND({Commercial?} = “yes”, {Close ID} = “”), "ready to import”))

field 1 is a single line text field and field 2 is a single select field. Both If statements work when using them separately.

Any help would be much appreciated!!

2 Replies 2

Your last comma is in the wrong place, it should be after the AND()'s closing parenthesis

Unfortunately I still receive an invalid error :confused: