you have quotes around the results of your if statement. so "5" as the result in
b1 is not going to = 5 in the formula in c1

remove the quotes
=IF(A1=0,0,IF(A141,5,IF(AND(A1<=41,A1=36),4,IF(A ND(A1<=35,A1=32),3,IF(AND(A1<=31,A1=27),2,IF(AND (A1<=26,A1=22),1,0))))))

--


Gary


"mohamadhafiz" wrote in message
...
Im having a problem trying to check the result via IF....

ok heres how it goes....

I have 2 checks that i need to do....

First is if a number is a certain Range... if it is... then it will be given
a certain Grade 1 - 5 the command is as FOLLOWs...

This is what i have in my B1 Cell....
=IF(A1=0,"0",IF(A141,"5",IF(AND(A1<=41,A1=36),"4 ",
IF(AND(A1<=35,A1=32),"3",
IF(AND(A1<=31,A1=27),"2",IF(AND(A1<=26,A1=22),"1 ","0"))))))


Next i need to check... if the person got more than Grade 3...
so in C1 i have
=IF(B1=3,"GOLD","SILVER")

It seems that i cant do it...

Is it not possible to have an IF Function to check an IF Result?

I really hope someone is able to assist me... Im very lost... Preferably if
i can get someone via MSN Messenger to discuss would be even greater....