IF function returns two different false responses

[original.grace]

Is there a way to have an embedded IF function that returns two different false responses?

For instance, I want both of these in the same formula:

=IF(ISTEXT(H2),"yes","no")
=IF(ISTEXT(E2),"yes","not seq")

 

[Ruddles]

A single formula can only return one value, although that one value can contain more than one piece of information. For example a formula might return a value of "Fred & Wilma" which is a single value containing two pieces of information.

My first thought would be something like this:-

=[COLOR=blue][B]IF(ISTEXT(H2),"H2 yes","H2 no") [/B][/COLOR]& "," & [COLOR=magenta][B]IF(ISTEXT(E2),"E2 yes","E2 not seq")[/B][/COLOR]

If that's not what you want, you'll need to tell us what you want returned for each possible combination of values of E2 and H2. I'm assuming the TEXT property is the criterion, so what do you want the formula to return in each of these cases:-

- E2 and H2 are both text
- E2 is text, H2 is not
- E2 is not text, H2 is
- neither E2 nor H2 is text

 

[Jonmo1]

Try

=IF(ISTEXT(H2),IF(ISTEXT(E2),"yes","not seq"),"no")

This returns "yes" if BOTH are text, "not seq" if E2 is not text, "no" if H2 is not text.

 

[DebugGalpin]

Is there a way to have an embedded IF function that returns two different false responses?

For instance, I want both of these in the same formula:

=IF(ISTEXT(H2),"yes","no")
=IF(ISTEXT(E2),"yes","not seq")

=if(AND(ISTEXT(H2),ISTEXT(E2)),"Yes",IF(ISTEXT(H2)=FALSE,"No",IF(ISTEXT(E2)=FALSE,"Not Seq","Error")))))

Popped the error in there but shouldn't make a difference works in my test

 

[original.grace]

Thanks!!! That totally worked!!!! =)

 

[Ruddles]

Which one?

 

[original.grace]

http://www.mrexcel.com/forum/member.php?u=69216jonmo1's worked, except I had to switch it around so it was

=IF(ISTEXT(E2),IF(ISTEXT(H2),"yes","no),"not seq")

 

[Scott Huish]

Should be: =IF(ISTEXT(E2),IF(ISTEXT(H2),"yes","no"),"notseq")