Can I use series of variables, in one "IF" ?
Thankyou!!
"Dana DeLouis" wrote:
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
|