G
Guest
I am trying to create an if statment where if the last two characters in a
cell are A1 or A2, "Y" appears in another cell. I've tried a couple of
formulas and nothing seems to be working.
=IF(OR($I5="*A1",$I5="*A2"),"Y"," ")
=IF($I5="*A1", IF($I5="*A2), "Y", " ")
Any suggestions?
cell are A1 or A2, "Y" appears in another cell. I've tried a couple of
formulas and nothing seems to be working.
=IF(OR($I5="*A1",$I5="*A2"),"Y"," ")
=IF($I5="*A1", IF($I5="*A2), "Y", " ")
Any suggestions?