View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AC man
 
Posts: n/a
Default What is wrong with this IF statement? need help.

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.