Can I do something like:
IF(A1="aa";"ab";"ac";"ad"),"")

Hi. Here you go. It's an array formula, so enter the formula with
Ctrl+Shift+Enter.

=IF(OR(A1={"aa","ab","ac","ad"}),"Yes","No")

HTH. :)
--
Dana DeLouis
Win XP & Office 2003


"nastech" wrote in message
...
Have something like:
IF(OR(A1="aa",A1="ab",A1="ac",A1="ad"),"")

Can I do something like:
IF(A1="aa";"ab";"ac";"ad"),"")

Running out of space.. thanks -nastech