Using IF function with OR

Hi, I need some help with the IF function, I created the formula to fit my condition of: If either C9 or C10 display Pass then display YES, otherwise display NO. =IF((OR(C9="Pass",C10="...

excel

Formulas and Functions

Damien_Rosario

Silver Contributor

Sep 19, 2018

Hi Deleted

If you are using Office 365, you have IFS at your disposal that can do multiple conditions.

I've given your conditions a crack, so maybe try this and see if it works for you?

=IFERROR(IFS(OR(C9="Pass",C10="Pass"),"YES",AND(C9="Fail",C10="N/A"),"NO",AND(C9="N/A",C10="Fail"),"NO",AND(C9="Fail",C10="Fail"),"NO",OR(C9="N/A",C10="N/A"),"N/A"),"")

IFERROR will catch any errors and make the cell blank (last condition in the formula is where I did that "")

IFS lets you do multiple criteria.

Best wishes with your spreadsheet!

Cheers

Damien

Anonymous

Sep 19, 2018

thanks for your help! It is now working :)

Forum Discussion

Using IF function with OR

Resources