electronic gradebook
shug
To convert scores to letter grades use a Lookup table and VLOOKUP functions.
OR a Lookup formula without a table
Assuming scores are in column A starting at A1.
In B1 enter this formula then drag/copy down column B
=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"})
Example only. Adapt for your scores and grades.
Note the curly braces internally.
Gord Dibben MS Excel MVP
On Fri, 23 Jun 2006 09:57:02 -0700, shug wrote:
how do i put in the formula to get a letter grade by using percentage. for
instace 100 - 90 = A
89 - 70 = B and so on using Excel.
Gord Dibben MS Excel MVP
|