help needed: I want to convert Scores (in percent) into Grades (A, B, C, D, or F)

[chaiwan]

Hi,

As a teacher I have to keep scores from my students' performance. I
normally use a MS Excel to add up my students scores from tests and
exams. The total "scores" will be in percentage

At the end of the course I will have to give "grades" to students.
Could you please help me to convert "scores(percent)" to "grades(A, B,
C, D, or F). Does IF function work?


Thank you for your kind help.

Ciao,
Chaiwan

 

[Bob Phillips]

Chaiwan,

IFs might work, but there is a much better way.

Firstly, construct a grading table like so

0% F
45% C
50% C+
55% B-
60% B
65% B+
70% A-
75% A
80% A+
90% A++

Let's assume that tis table is in F1:G9, and the score is in A1. To get the
grade, use

=LOOKUP(A1,F1:G9)

Obviosuly, you can change the thresholds and grades to suit.

--

HTH

RP
(remove nothere from the email address if mailing direct)