Re: if statements with multiple returns

Your data seems to be in F3, so try this:

=IF(OR(MID(F3,14,2)="IP",MID(F3,14,2)="IV"),MID(F3,14,2),"not present")

You can change the "not present" message to something more to your
liking, then copy the formula down if you have similar strings to test
below F3.

Hope this helps.

Pete

Batman wrote:

Hi Dave,

Didn't work for me... how about this way..this returns ip..

=IF(ISNUMBER(SEARCH("IP",F3)),"IP","")

I just can't figure out how to enter multiple values to get mulitple returns.

Ryan

"Dave F" wrote:

=IF(LEFT(A1,14)="i",CONCATENATE(LEFT(A1,14),LEFT(A1,15),"")

Dave
--
Brevity is the soul of wit.


"Batman" wrote:

Hi someone,

I'm trying to find and return specific text (the 14th and 15th character)
from a cell, but only if its one of 6 different values (ex. "ip" or "iv")

can someone provide a formula that could return only these 2 values, and i
should be ok to replicate it from there??

Thanks,

.

Relevant Pages

  • Re: if statements with multiple returns
    ... liking, then copy the formula down if you have similar strings to test ... "Batman" wrote: ... should be ok to replicate it from there?? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: if statements with multiple returns
    ... Assuming that the string of interest is in A2 and the list of specific ... Batman wrote: ... I'm trying to find and return specific text (the 14th and 15th character) ... can someone provide a formula that could return only these 2 values, and i should be ok to replicate it from there?? ...
    (microsoft.public.excel.worksheet.functions)
  • Legends vs Elseworlds (was Re: How old is Black Canary anyway?
    ... Batman storyline about he and Talia's son...you don't think it might ... confuse you when you then see Ollie back, or a new Spectre, etc. ... There is something to be said for the classic version of a character. ... By telling stories of the "iconic" period you are able to appeal to ...
    (rec.arts.comics.dc.universe)
  • Re: Jason Todd due for a "power down"?
    ... character that is relevant to my question, ... now Teen Titans) have written the "new" Jason Todd as ... Seemingly a notch or so below Batman. ...
    (rec.arts.comics.dc.universe)
  • Re: Justice League of America #8: How Can You Read This (Spoilers)
    ... Regardless of the fact that Shiva or Batgirl are better trained than ... I have - some douche creates a character out of nowhere and just ... anti-hero who can kill Batman easily and maybe has reason to, ...
    (rec.arts.comics.dc.universe)