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

[Guest]

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).

 

[Aladin Akyurek]

Create a table something like...

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

and invoke:

=LOOKUP(Points,Table)

 

[Guest]

Take a look at:

http://www.microsoft.com/education/ManagingGrades.mspx