IF statement quick help.

[Ryan1996]

I have the below formula

=IF(AND(OR(H2="#N/A",I2="#N/A", J2="#N/A")),"FAIL","PASS")

In the results it either brings "PASS" when passed or shows "#N/A" when failed.

How can i get this to say PASS when it's passed and FAIL when it's Failed?

 

[Finalfight40]

Do you want it to say fail when any of them display #N/A?

For example what if there is:

1 #N/A?
2 #N/A?

in these cells

 

[Ryan1996]

IF H2 OR I2 OR J2 say "#N/A" then FAIL otherwise if "#N/A" does not appear in any then PASS

 

[Finalfight40]

Try this:

=IF(COUNTIF(H2:J2, "#N/A")>=1, "FAIL", "PASS")

 

[Finalfight40]

Also your way can work as well but you didnt need the AND function and you can use ISNA instead of ="#N/A":

For example:

=IF(OR(ISNA(H2),ISNA(I2), ISNA(J2)),"FAIL","PASS")

 

[Ryan1996]

Wonderful, first worked like a charm. Great to know about the ISNA too, i knew it woulda worked somehow just couldn't figure it out. Thanks for the info!!

 

[Finalfight40]

Your welcome