If you have a large list of items to which A1 is being compared, one approach
is to put the list in a column and use the MATCH() function. If MATCH can
find a row then you have TRUE.
--
Gary's Student


"nastech" wrote:

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