hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL)

C

cicely

I am trying to create a grade book. I know thee is a way that I can function
the total amount of points to a letter grade ( A-F).
 
A

Aladin Akyurek

Create a table something like...

0,F
50,E
60,D
70,C
80,B
90,A

and invoke:

=LOOKUP(Points,Table)
 
Top