ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL) (https://www.excelbanter.com/excel-worksheet-functions/47066-how-can-i-convert-numerical-points-into-letter-grade-school.html)

cicely

hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL)
 
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)

cicely wrote:
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).


Gary''s Student

Take a look at:

http://www.microsoft.com/education/ManagingGrades.mspx
--
Gary''s Student


"cicely" wrote:

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



All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com