You're approaching the limit of nested functions. But since you're working with
text, you could just concatenate your strings:

=IF(H6=0,"0""","")
&IF(AND(H60,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(H6350.2,H6<601),"12""","")
&IF(AND(H6601.1,H6<901),"14""","")

But what happens at 101, 151, 201, ...?

I would think you'd want <= or = in a few of those statements.



AC man wrote:

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.

--

Dave Peterson