I have four cells with the following data:
A1=NA
C1=NA
E1=Hexes location 1
G1=Perl Location 2
I want to us an if statement and use the OR operator for cells A1 and C1 to match on "NA" and the And operator for cells E1 and G1 to find a match off the abbreviation "hex"
/code/
if(Or(A1="NA", C1="NA",And(E1="*Hex*", G1="*Hex*")),"true", "false")
/code/
What am i missing? Thanks.
Bookmarks