Checking cells for part of a text string
 

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

Checking cells for part of a text string
 

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

If this post helps click Yes
---------------
Jacob Skaria


"RoryDM" wrote:

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

Checking cells for part of a text string
 

Hi,

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

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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