Thankyou... been a problem for awhile.. later

"Peo Sjoblom" wrote:

One way

=IF(LEFT(A1,1)="b","do this","do that")

wildcards can be used in several function

but not in logical functions, so you have to use workarounds,
for your example LEFT will work, for *b* you can use

=IF(ISNUMBER(SEARCH("b",A1)),"do this","do that")

for *b

=IF(RIGHT(A1,1), and so on



--
Regards,

Peo Sjoblom

(No private emails please)


"nastech" wrote in message
...
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..