Hi Mani ,
We have 3 variables , in cells D5 , E6 and G10.
D5 can take two states , D5 < 34 and D5 = 34.
E6 can take three states , E6 < 6 , E6 between 10 and 15 , E6 > 15
G10 can similarly take 3 states , G10 < 75 , G10 between 75 and 90 , G10 > 90
These 3 variables with these different states can have a total of 2 x 3 x 3 = 18 different combinations.
Out of these 18 combinations , you have considered only 3 combinations for which you are specifying outputs ; for the remaining 15 combinations , in the absence of a specified output , Excel will return the value False.
Of course , if the data is such that these 15 combinations will never occur in practice , there is no problem.
Try the following :
=IF(OR(D5 < 34,E6 > 15,G10 < 75), "C", IF(AND(D5 = 34,E6 > 10,E6 < 15,G10 > 75,G10<90), "B", IF(AND(D5 = 34,E6 < 6,G10 > 90), "A", "Not Specified")))
Narayan