Checking cells for part of a text string

[RoryDM]

I'm trying to create a conditional formula that will be used only if the
cells in column A have a certain begining to the text that is in it.
=IF(Isnumber(search("KM2*"or"KMC*"or"KMT2*",$A9,1))),1/$F9,IF($C9<2003,IF(F9<=0,0,0.85/F9),IF(F9<=0,IF(F9>-96,1/(96+F9),0),0.85*0.7/(0.3*$D9*12+0.7*F9))))
You can ignore the end of the formula, I'm only concerned with the begining
of the first IF statement.
Thanks

 

[Jacob Skaria]

=COUNT(SEARCH({"KM2","KMC","KMT2"},$A9))

If this post helps click Yes

 

[Ashish Mathur]

Hi,

You may try the following array formula (Ctrl+Shift+Enter). D2024
contains KM2, KMC etc.

=OR(ISNUMBER(SEARCH($D$20:$D$24,$A9)))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com