Changing numbers/percentages to letter grades
Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?
"Elkar" wrote:
You could use the LOOKUP function. Something like:
=LOOKUP(A6,{0,60,70,80,90},{"F","D","C","B","A"})
You can add more numbers/grades if you want to include + and - grades.
HTH,
Elkar
"Preston Steele" wrote:
I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?
|