thanks for the reply. ok, so i need this information
=IF(AND(F626,M6<110),"FAIL",IF(AND(F6<26,M6<135), "FAIL",IF(AND(F626,M6<150),"3rd
Class",IF(AND(F6<26,M6<175),"3rd Class",IF(AND(F626,M6<200),"2nd
Class",IF(AND(F6<26,M6<225),"2nd Class", IF(AND(F626,M6=200),"1ST
CLASS",IF(AND(F6<26,M6=225),"1ST CLASS"))))))))
but i cant nest more than 7 functions, so it stops working after the "2nd
class" statements. how can i write this better?
"David Biddulph" wrote:

Look at Excel help for the syntax of the AND() function, then use that AND()
function as the condition part of your IF() function.

Also, don't forget to specify the alternative output for when your IF()
condition is NOT satisfied. If you don't specify an output, it will default
to the Boolean FALSE, which may not be the output you want.
--
David Biddulph

"Desdinova" wrote in message
...
ok, for some reason i cannot write a new post (maybe i can only have
one?).
So i will ask it he how can i add to an "if" function. As in, i want to
say =IF M626 AND T6<135, "1st class"

can i do this, and effectively add two conditions for one if statement?