ISBLANK and IF formula Error

[jmmain24]

Hi all,

I have the following formula that works perfectly:

=IF(K17>=2, "Very Superior", IF(K17>=1.33, "Superior", IF(K17>=0.6, "High Average", IF(K17>=-0.5, "Average", IF(K17>=-1, "Low Average", IF(K17>=-1.5, "Mildly Impaired", IF(K17>=-2, "Mildly to Moderately Impaired", IF(K17>=-2.534, "Moderately Impaired", IF(K17>=-2.734, "Moderately to Severely Impaired", "Severely Impaired")))))))))

I'm trying to add an IFBLANK statement to this formula so that if K17 is blank then the formula produces a blank cell. (Right now it produces "Very Superior" and I don't want that to appear if there is no associated value in K17). I've tried:

IF(isblank(K17), "", (K17>=2, "Very Superior", IF(K17>=1.33, "Superior", IF(K17>=0.6, "High Average", IF(K17>=-0.5, "Average", IF(K17>=-1, "Low Average", IF(K17>=-1.5, "Mildly Impaired", IF(K17>=-2, "Mildly to Moderately Impaired", IF(K17>=-2.534, "Moderately Impaired", IF(K17>=-2.734, "Moderately to Severely Impaired", "Severely Impaired")))))))))))

...but it is not working. I'm a bit new at this. Any suggestions on how to adjust the former formula to produce a blank value if K17 is blank???

 

[Jonmo1]

If K17 also contains a formula, and that formula returns "", that is NOT blank. IT's actually a text string.

Instead of IF(ISBLANK(K17)
Try
IF(K17=""

 

[philwojo]

Try this:

=IF(ISBLANK(K17), "", [COLOR=#ff0000]IF[/COLOR](K17>=2, "Very Superior", IF(K17>=1.33, "Superior", IF(K17>=0.6, "High Average", IF(K17>=-0.5, "Average", IF(K17>=-1, "Low Average", IF(K17>=-1.5, "Mildly Impaired", IF(K17>=-2, "Mildly to Moderately Impaired", IF(K17>=-2.534, "Moderately Impaired", IF(K17>=-2.734, "Moderately to Severely Impaired", "Severely Impaired"))))))))))

I think you just needed to add the "IF" back in after the isblank check, see the part highlighted in red.

 

[jmmain24]

Copy pasted Philwojo's formula but substituted Jonmo's text string theory and it worked!

Thanks to you both. you have no idea how grateful I am!

 

[Jonmo1]

You're welcome.