If AND statement for cells with #N/A

[Jaymann]

How do you make an if statement that identifies data that has "#N/A" in 2 seperate cells?

So if both cells have that error (#N/A), how do I return "check" ?

This is what I have in a formula for now.


=if(and(isna(BB102), isna(BC102) "", "Check")

And this does not work

Also this does not work either.


=IF(AND(BB102=#N/A, BC102=#N/A), "check", "")

Any help would be greatly appreciated. Thanks!

[vlady]

something like this

you missed a comma and close parentheses here

=IF(AND(isna(BB102), isna(BC102)),"","Check")

change the underlined if not the requirement to ,"check,"")

[Jaymann]

Thank you! Works perfectly!