Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Macro be run as part of an IF() statement | Excel Worksheet Functions | |||
Can I create an IF statement that looks for part of a string of te | Excel Worksheet Functions | |||
Excel XP removes AS part of statement | Excel Programming | |||
Excel XP removes AS part of statement | Excel Programming | |||
Excel XP removes AS part of statement | Excel Programming |