=IF(H6=0,0,IF(H6<101,"6""",IF(H6<151,"7""",IF(H6<2 01,"8""",IF(H6<275.1,"9""",IF(H6<350.1,"10""",IF(H 6<601,"12""",IF(H6<901,"14""",0))))))))

Try something like this out, adjust values, as needed ( in your example the
figure 151 would not register as it you have less than 151 and in the next
section you ask if its greater than 151 thus making this number void, you
may have wanted to do this im not sure ?

Pete

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"AC man" wrote in message
...
This statement works fine but I want the cell to say 0" if the cell H6 has
a
zero in it. As the stetments stands right now it displayes 6" in the cell
if
H6 is 0. How can I make that happen?

=IF(H6<101,"6""",IF(AND(H6101.1,H6<151),"7""",IF( AND(H6151.1,H6<201),"8""",IF(AND(H6200.1,H6<275. 1),"9""",IF(AND(H6275.2,H6<350.1),"10""",IF(AND(H 6350.2,H6<601),"12""",IF(AND(H6601.1,H6<901),"14 """)))))))

Please help me correct this statment. Thank you.