if command
 

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

if command
 

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

if command
 

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


On Fri, 5 Jan 2007 02:08:50 +0530, 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,"D 19",IF(C$2059,"D20","F"))))

any help would be very grateful