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
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
I'm not sure how to implement wildcards in a formula like that, but this should work
=IF(LEFT(B2, 3) = "TMI",1,0)
Excel formula interpret all sting values literally so TMI* <> TMIanything
2+2=9 ... (My Arithmetic Is Mental)
You could use:
=COUNTIF(B2,"TMI*")
Regards,
Rory
Microsoft MVP - Excel
Not quite true.Originally Posted by unmarkedhelicopter
Yes an IF formula will look for an exact match but COUNTIF or SUMIF can be used with wildcards.
I didn't know that, thanks rory & Norie.
2+2=9 ... (My Arithmetic Is Mental)