Grading Curve Excel Question

[Skillz]

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!!!

[Smitty]

Welcome to the Board!

Something like this do for ya?

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
B2A6B6A7B7A8B8A9B9A10B10A11B11A12B12A13B13A14B14A15B15A16B16A17B17A18B18A19B19A20B20A21B21A22B22A23B23A24B24A25B25 =
	A	B	C	D
1	Grade*Entry	14	*	*
2	Grade*=*	69	*	*
3	*	*	*	*
4	Key	Grade	*	*
5	10	65	*	*
6	11	66	*	*
7	12	67	*	*
8	13	68	*	*
9	14	69	*	*
10	15	70	*	*
11	16	71	*	*
12	17	72	*	*
13	18	73	*	*
14	19	74	*	*
15	20	75	*	*
16	21	76	*	*
17	22	77	*	*
18	23	78	*	*
19	24	79	*	*
20	25	80	*	*
21	26	81	*	*
22	27	82	*	*
23	28	83	*	*
24	29	84	*	*
25	30	85	*	*
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Hope that helps,

Smitty

[Zack Barresse]

hi Skillz, welcome to the board!

to best get your spreadsheet concept across to the board members here, try posting with Colo's HTML maker (link at bottom of page).

that is if Smitty didn't sate you first

hope this helps.

[Skillz]

Very much so!
Thanks a lot!