Forum Discussion
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="...
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
- thanks for your help! It is now working :)