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..........