Formula Referencing cell with #N/A

[klitton7]

I have a formula that I am trying to add additional criteria to.
Current version:
=IF(OR(V1684="UNK",V1684="ZZZZZ","PENDING","")

I want to add criteria that would evaluate cell AC1684. If the formula has returned #N/A, I would like "PENDING" to be the result.

I have tried to write this formula several times -- here is an attempt: =IF(OR(V1684="UNK",V1684="ZZZZZ",V1684="#N/A"),"PENDING","")

Thank you

 

[hagia_sofia]

Hello, would this work for you:

=IF(ISNA(V1684),"PENDING",IF(OR(V1684="UNK",V1684="ZZZZZ"),"PENDING",""))

 

[Scott Huish]

=IFNA(IF(OR(V1684={"UNK","ZZZZZ"}),"PENDING",""),"PENDING")

 

[klitton7]

Hello, would this work for you:

=IF(ISNA(V1684),"PENDING",IF(OR(V1684="UNK",V1684="ZZZZZ"),"PENDING",""))

Thank you very much!