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]

HOTPEPPER's approach may be better for that scenario.

 

[lenze]

You can use VLOOKUP instead. What are your cut-offs?
lenze

 

[toleafs]

thanks , Hotpeppers worked....