=IF(OR(A1=B(x),A1=C(x)),Value if True, Value if false)

by using the OR function with the IF function you can increase the
number of conditions allowed. The AND function also works as above
except all the conditions must be met instead of only one.
Hope this helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=488423