To test if A1 is equal to B1 or B2 is
=IF(OR(A1=B1,A1=B2),"True","")

Wildcards are used to match characters in a search etc, not to modify
formula ranges.



nastech Wrote:
I've been trying to make wild cards work, don't see any actual equation
examples in help. Just the simple version for something like:

if(a1="b"*,"true")

for cell a1 = b1 or b2..
don't know where to put the quotation marks/ wildcards, isn't working,
thanks.
obviously needs to be a number field..


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476689