If Statement Problem Part 2!

[Ann]

Really sorry..

My daughter just pressed the enter key!!

.... what I was saying is that the three letter sequence
may be anywhere in the cell.

Thanks again,

Ann

 

[Guest]

The formula I gave you looks for an instance of the sub-string in the main
string. Find returns the start position...

HTH

 

[Bob Phillips]

Really sorry..

My daughter just pressed the enter key!!

A likely story

... what I was saying is that the three letter sequence
may be anywhere in the cell.

=IF(AND(ISNA(B1),OR(ISNUMBER(FIND("stw",D2)),ISNUMBER(FIND("iwo",D2)))),"1",
"0")

 

[JE McGimpsey]

Then

=ISNA(B1)*(SUM(COUNTIF(D2,"*"&{"stw","iwo"}&"*"))>0)

or

=ISNA(B1)*((ISERR(FIND("stw",D2))+(ISERR(FIND("iwo",D2))))=1)

 

[Guest]

Bob... Why return the 1 and 0 as text. And are you insinuating that we
shouldn't blame our kids. That takes half the fun out of having them.

 

[Bob Phillips]

Because the OP used text in her original mail (terrible reason I know, but I
wasn't up for questioning it ).

Mine girls are grown up Jim, so they blame me. Believe me, the fun is
gone

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Well I'll be darned. You are right... Text... Shows how close I was watching.
In the future I'll not question your infintite wisdom. (I'll leave that to
your girls. They apparently have more practice anyway).

 

[Bob Phillips]

LOL. They see it as infinite stupidity, hardly worth bothering to question


Bob