IF/AND Formula

Joshua Rose

Hi, I am following identical logic to another formula in my sheet that is working, so I cannot for the life of me figure out why this is not:

 

=IF(AND(Eval Payment Status]1 = "Appointment Pending (pay plan)", [Initial Pay Plan Amount Due]1 = 0), 1, 0)

 

Here, I am trying to establish that IF Eval Payment Status shows Appointment Pending (pay plan), AND Initial Pay Plan Amount Due is blank, then check the box.

 

Any thoughts greatly appreciated. 

 

 

akay

It looks like you're missing the opening bracket for your cell named [Eval Payment Status]1

Joshua Rose

Thx!