Nested IF Statement

[toleafs]

I've been looking for this on the message board but no luck. Any help would be GREATLY appreciated... I am trying to write a statement that will give me a result based on the value in cell I2.
For instance, if cell I2 was 4 - result PH; but if cell I2 was 9 - result is EH.

IF(I2>=0, I2<=6,"PH", IF(I2>7, I2<=10, "EH"))

hope this makes sense.
Thanks

 

[VoG]

Try

=IF(AND(I2>=0, I2<=6),"PH", IF(AND(I2>7, I2<=10), "EH"))

 

[texasalynn]

You would want to put the formula in that cell
=IF(and(I2>=0, I2<=6),"PH", IF(and(I2>7, I2<=10), "EH",""))

edit: should that be >=7 not >7

 

[Scott Huish]

Maybe:

=LOOKUP(I2,{0,"PH";7,"EH";11,""})

 

[toleafs]

Question,
If I2 is a formula, this doesn't seem to work? Any suggestions?

 

[texasalynn]

post a sample of your data. Formulas won't matter

 

[toleafs]

I am using: =IF(AND(I2>=0, I2<=6),"PH", IF(AND(I2>7, I2<=10), "EH")) , it returns FALSE.

....I2 Contains the formula: =Right(H2,2)

 

[lenze]

The RIGHT function returns a Text string. Change your formula to

=RIGHT(H2,2)*1

lenze

 

[toleafs]

Thank You, it works great

 

[toleafs]

I ran into another issue....I have 7 conditions to meet and excel does not allow me to nest 7 IF statements. Any ideas?