IF formula

terri.white82166

I want "In progress" to display if the check # field is blank or CCC Approved field is Yes, otherwise I want "Complete" to display.    I've tried this formula but the syntax is wrong.

=IF(ISBLANK([Check #]1), "In Progress", IF([CCC Approved?]1=YES, "In Progress", "Complete"))

 

Nic Larsen

Just missing quotes around the "YES". Otherwise it was right. Added @row. 

=IF(ISBLANK([Check #]@row), "In Progress", IF([CCC Approved?]@row = "YES", "In Progress", "Complete"))

Paul Newcome

Could also be simplified to

 

=IF(OR(ISBLANK([Check #]@row), [CCC Aproved]@row = "YES"), "In Progress", "Complete")