IF formula giving me #INCORRECT ARGUMENT

Sidonia Posteuca

I am using this formula to set status' in my sheet.

=IF(ISBLANK(Cost4), "Request Submitted", "Request Reviewed/Priced", IF(CONTAINS("Approve", [CEO Approval]4), "CEO Approved"))

I am getting an #INCORRECT ARGUMENT error. What am I doing wrong?

Paul Newcome

Try this instead...

=IF(CONTAINS("Approve", [CEO Approval]4), "CEO Approved", IF(ISBLANK(Cost4), "Request Submitted", "Request Reviewed/Priced"))

Paul Newcome

Try this instead...

=IF(CONTAINS("Approve", [CEO Approval]4), "CEO Approved", IF(ISBLANK(Cost4), "Request Submitted", "Request Reviewed/Priced"))

Sidonia Posteuca

It works! Thank you!

Paul Newcome

Happy to help. 👍️