If, And, Or in one formula

AJudge

Hi all

I am trying to write a formula but I don't know how to use "OR" to accomplish what I need. Here is an outline.

IF Engineering Review Result = "Approved" AND IF Planner Review Result = "Approved", AND IF either (Supplier QA Review Result = "Approved" OR Skip Supplier QA Review is CHECKED), then write "Complete".

I need it to check either that the Supplier QA Review Result says "Approved" or if not, does the Skip Supplier QA Review have a check mark. One or the other must be true but not both.

Here is a working formula without the OR part.

=IF(AND([Engineering Review Result]@row="Approved", [Planner Review Result]@row="Approved", [Supplier QA Review Result]@row="Approved"),"Complete", "Not Complete")

Any help appreciated!

AJ

Kelly Moore

Hey @AJudge

Try this:

=IF(AND([Engineering Review Result]@row="Approved", [Planner Review Result]@row="Approved", OR([Supplier QA Review Result]@row="Approved",[Skip Supplier QA Review]@row=1)),"Complete", "Not Complete")

Does this work for you?
Kelly

Kelly Moore

Hey @AJudge

Try this:

=IF(AND([Engineering Review Result]@row="Approved", [Planner Review Result]@row="Approved", OR([Supplier QA Review Result]@row="Approved",[Skip Supplier QA Review]@row=1)),"Complete", "Not Complete")

Does this work for you?
Kelly

AJudge

Great this works perfectly! Thank you for your help!