PDA

View Full Version : Solved: Wildcards



philfer
12-21-2007, 12:12 PM
This may seem like a really basic question but I have an IF statement in excel that goes like :-

=IF(B2="TMI*",1,0)

but it isnt finding TMI-New York

Does anyone know why not?

Thanks

tpoynton
12-21-2007, 12:30 PM
I'm not sure how to implement wildcards in a formula like that, but this should work

=IF(LEFT(B2, 3) = "TMI",1,0)

unmarkedhelicopter
12-21-2007, 01:11 PM
Excel formula interpret all sting values literally so TMI* <> TMIanything

rory
12-21-2007, 02:40 PM
You could use:

=COUNTIF(B2,"TMI*")

Norie
12-21-2007, 02:45 PM
Excel formula interpret all sting values literally so TMI* <> TMIanything
Not quite true.

Yes an IF formula will look for an exact match but COUNTIF or SUMIF can be used with wildcards.

unmarkedhelicopter
12-21-2007, 03:51 PM
I didn't know that, thanks rory & Norie.