The problem you're running into is that your first IF statement is returning
text values rather than numbers. Your second IF statement is looking for
numbers.

Try removing the quotes from your Grades in the first IF. The quotes tell
Excel to treat the result as Text instead of a Number. The number 1 and the
text value 1 may look the same to you, but Excel treats them differently.

Also, you could shorten up your first formula a bit. No need for all of the
AND functions.

=IF(A141,5,IF(A1=36,4,IF(A1=32,3,IF(A1=27,2,IF (A1=22,1,0)))))

The A1=36 is only evaluated when A141 is False. Therefore, it is
redundant to include the A1<=41 part, etc...

HTH,
Elkar


=
"mohamadhafiz" wrote:

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... unless B1 is a just a number and does not
contain AN IF Formula....

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