IF Formula help. 2 chances for errors

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Trying to use this formula, and it just doesn't respond.
Looking to extract numbers from column C,
if that is an error, look again in column F,
if that is an error as well, return" Burger King"

The formula would look sort of like this:
=IF(ISERROR(MID(C2,1,FIND("-",C2,1)-1)),=if(iserror(MID(F2,1,FIND("-",F2,1)-1),"Burger
King")))

(If column C begins with "letters" instead of numbers, it will
produce the error. Thats why we go to column F If an error is also
present in F, then enter "Burger King" as the result.

Many thanks for ideas, or corrections in nomemclature.

Pierre
 
Trying to use this formula, and it just doesn't respond.
Looking to extract numbers from column C,
if that is an error, look again in column F,
if that is an error as well, return" Burger King"

The formula would look sort of like this:
=IF(ISERROR(MID(C2,1,FIND("-",C2,1)-1)),=if(iserror(MID(F2,1,FIND("-",F2,1)­-1),"Burger
King")))

(If column C  begins with "letters" instead of numbers, it will
produce the error.  Thats why we go to column F  If an error is also
present in F, then enter "Burger King" as the result.

Many thanks for ideas, or corrections in nomemclature.

Pierre
Click to expand...

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
Don, thank you for the offer to review. have made progress, and the
task has changed slightly.
There are numbers in a cell, they can be at the left side, or the
right, or in the middle. There are numerous variable text and other
characters also within the cell.
The task: If the numerals appear in the middle surrounded by spaces,
dashes, or any text character, ignore and enter "Burger King".
If the numerical string is clearly at the beginning or the end, just
return those numerals.

Examples:
"125-pink" will return 125
"95238- Omaha" will return 95238
"Wilson 410 -Red" returns "Burger King"
"Bob - S 95634" returns 95634

It's messy, but thank you for any thoughts.
Pierre
 
Back
Top