Grading Curve Excel Question

Skillz · Mar 30th, 2004, 08:03 PM

I am a teacher and I am attempting to create a spreadsheet which will calculate a numerical grading curve.

Here is what I have set up so far:

Row L6:L26 I have the numbers 10 - 30 they represent what I'm calling the 'key'

Row M6:M26 I have 65, 66, 67, 68, 69, 70, 72, 74, 76, 78, 80... etc. which represent the 'grade'.

What I'm trying to accomplish is - If i put a number from the 'key' into a cell (for argument's sake, lets say cell B6) I want it to show the 'grade' in another cell. (Lets say E6).
If this is unclear, please PM me or reply and I would be happy to send you my sheet. Any help would be greatly appreciated!!!

Mar 30th, 2004, 08:03 PM	#1
Skillz Join Date: Mar 2004 Posts: 2	Grading Curve Excel Question I am a teacher and I am attempting to create a spreadsheet which will calculate a numerical grading curve. Here is what I have set up so far: Row L6:L26 I have the numbers 10 - 30 they represent what I'm calling the 'key' Row M6:M26 I have 65, 66, 67, 68, 69, 70, 72, 74, 76, 78, 80... etc. which represent the 'grade'. What I'm trying to accomplish is - If i put a number from the 'key' into a cell (for argument's sake, lets say cell B6) I want it to show the 'grade' in another cell. (Lets say E6). If this is unclear, please PM me or reply and I would be happy to send you my sheet. Any help would be greatly appreciated!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode