MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If a1 = "AA" or a1 = "BB"


Posted by JC on February 05, 2002 1:19 PM

If a1 = "AA" or a1 = "BB" can I make such a statement in a cell without nesting 2 ifs?


Posted by laura jean on February 05, 2002 1:28 PM

check out OR

=OR(a1="AA",a1="BB")