If Statement Problem Part 2!
 

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

If Statement Problem Part 2!
 

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

HTH

"Ann" wrote:

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

If Statement Problem Part 2!
 

"Ann" wrote in message
...
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)),ISNUM BER(FIND("iwo",D2)))),"1",
"0")

If Statement Problem Part 2!
 

Then

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

or

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

In article ,
"Ann" wrote:

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.

If Statement Problem Part 2!
 

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" wrote:



"Ann" wrote in message
...
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)),ISNUM BER(FIND("iwo",D2)))),"1",
"0")

If Statement Problem Part 2!
 

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)


"Jim Thomlinson" wrote in message
...
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" wrote:



"Ann" wrote in message
...
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)),ISNUM BER(FIND("iwo",D2)))),"1",
"0")

If Statement Problem Part 2!
 

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" wrote:

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)


"Jim Thomlinson" wrote in message
...
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" wrote:



"Ann" wrote in message
...
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)),ISNUM BER(FIND("iwo",D2)))),"1",
"0")

If Statement Problem Part 2!
 

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

Bob


"Jim Thomlinson" wrote in message
...
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" wrote:

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)


"Jim Thomlinson" wrote in
message
...
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" wrote: