Remove the quotes around D17.
--
Brevity is the soul of wit.


"afromaniac" wrote:


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

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


=IF(C8C$17,"D17",IF(C8C$18,"D18",
IF(C8C$19,"D19",IF(C$2059,"D20","F"))))

any help would be very grateful


--
afromaniac
------------------------------------------------------------------------
afromaniac's Profile: http://www.officehelp.in/member.php?userid=5679
View this thread: http://www.officehelp.in/showthread.php?t=1310385

Posted from - http://www.officehelp.in