What is wrong with this IF statement? need help.
I didn't notice the 101.1. But I'd still use:
&IF(AND(H6=101,H6<151),"7""","")
for things like: 101.00001
Dave Peterson wrote:
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
--
Dave Peterson
|