Forum Discussion

Anonymous's avatar
Anonymous
Sep 19, 2018

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
BobOrrell's avatar
BobOrrell
Iron Contributor
Sep 19, 2018

If you don't have 365, or just want to continue using If you can use

=IF(OR(C9="Pass",C10="Pass"),"Yes",IF(AND(C9="N/A",C10="N/A"),"N/A","No"))

and to make sure I understood, either cell says Pass, then the result is Pass, both cells say N/A, the result is N/A, anything else will say No

  • Anonymous's avatar
    Anonymous
    Sep 19, 2018

    Thanks for your help! I managed to get it working.

Resources