if condition with iserror help

hi guys,

well, dont knw if my issue is quiet nawmal....i m havin prb with a formula which says this

=IF(I5>=0.9,"A",IF(AND(I5>=0.85,I5<0.9),"B",IF(AND(I5>=0.75,I5<0.85),"C",IF(AND(I5>=0.7,I5<0.75),"D",IF(AND(I5<0.7),"E")))))

The above formula says that if the cell I5 value is greater than or equal to 0.9 then it will return A value, and so on....

Now when there is no value in the I column it unnecessarily considers some value and enters A in the return value column, is it possible that it should not consider anything and leave the cell blank...i tried using iserror and isblank but it is givin me error in formula....

chintu..........

Use:

=IF(ISNUMBER(I5),IF(I5>=0.9,"A",IF(AND(I5>=0.85,I5<0.9),"B",IF(AND(I5>=0.75,I5<0.85),"C",
IF(AND(I5>=0.7,I5<0.75),"D",IF(AND(I5<0.7),"E"))))),"")

I think you are getting A because there is some non-blank character in that cell. If the cell is blank, you should get E as this evaluates to 0. If you use the above one, it checks for any numerical characters and then only evaluates your formula.

- Mangesh

This should also work
=IF(ISNUMBER(I5),CHAR(65+(I5<0.7)+(I5<0.75)+(I5<0.85)+(I5<0.9));"")

Ola Sandstrom