Trouble using nested IF formula with AND function

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!!

+27

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

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:

Sign up