if command

[afromaniac]

I am a teacher in a school and due to the large amount of test we do an
the subsequent analysis I was wondering if any on could help me out i
this problem.

All of our tests have different grade boundaries and as such I woul
like a easy to use if command. I tried the following but the proble
occurs as it gives me a grade of D17 instead of the grade that the cl
refers to.


=IF(C8>C$17,"D17",IF(C8>C$18,"D18"
IF(C8>C$19,"D19",IF(C$20>59,"D20","F"))))

any help would be very gratefu

 

[Gord Dibben]

Remove the double quotes from the cell references.

Excel sees anything in double quotes as text.

For info only.........There are other methods of scoring/grading

With column of scores in A enter this in B1 and double-click to copy down.

=LOOKUP(A1,{0,50,60,70,80},{"E","D","C","B","A"})

Adjust for score ranges or more letter grades like C+, B- etc.

=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D","C-","C","C+","B","B+","A"})

Adjust to suit.


Gord Dibben MS Excel MVP