grades computation

[kinalas]

how can i make a worksheet/formula that automatically look for the equivalent score in a given transmutation table.

example: i have an exam of 10 items, what will be my formula to so that it will automatically look for the equivalent score under the transmutation table of 10 items

 

[joey21jns]

its more than a decade but i'm currently having the same problem right now can someone help me solve it, i need the percentage as output where my input will be the number of items and the students score, i already prepared a table of quizzes with items ranging from 30 to 115 items

30	35	40	45	50	55	60	65	70	75	80	85	90	95	100	105	110	115	120	125
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	72
10	12	14	16	18	19	19	22	25	27	28	30	32	34	36	38	39	41	43	45	73
11	13	15	17	19	20	22	24	26	28	29	31	33	35	37	39	40	42	44	46	74
12	14	16	18	20	22	24	26	28	30	32	34	36	38	40	42	44	46	48	50	75
14	16	18	20	22	24	26	29	31	33	35	37	39	41	44	46	48	50	52	54	76
15	17	19	22	24	26	29	31	33	35	38	40	42	45	47	49	52	54	56	59	77
16	18	20	23	25	28	31	33	35	38	40	43	45	48	50	53	55	58	60	63	78
17	19	22	25	27	30	33	35	38	41	43	46	49	51	54	57	59	62	65	67	79
18	20	23	26	29	32	35	37	40	43	46	49	52	55	57	60	63	66	67	72	80
19	22	25	28	31	34	37	40	43	46	49	52	55	58	61	64	67	70	73	76	81
20	23	26	29	32	36	39	42	45	48	52	55	58	61	64	67	71	74	77	80	82
21	24	27	31	34	37	41	44	48	51	54	58	61	64	68	71	74	78	81	85	83
22	25	29	32	36	39	43	46	50	54	57	61	64	68	71	75	78	82	85	89	84
23	27	30	34	38	41	45	49	52	56	60	64	67	71	75	78	82	86	89	93	85
24	28	31	35	39	43	47	51	55	59	63	66	70	74	78	82	86	90	94	97	86
25	29	33	37	41	45	49	53	57	61	65	69	73	78	82	86	90	94	98	102	87
26	30	34	39	43	47	51	55	60	64	68	72	77	81	85	89	93	98	102	106	88
27	31	36	40	44	49	53	58	62	66	71	75	80	84	88	93	97	102	106	110	89
28	32	37	42	46	51	55	60	64	69	74	78	83	87	92	96	101	106	110	115	90
29	34	38	43	48	53	57	62	67	72	76	81	86	91	95	100	105	110	115	119	91
30	35	40	45	50	55	59	64	69	74	79	84	89	94	99	104	109	114	118	123	92

<colgroup><col span="21"><col span="3"></colgroup><tbody>
</tbody>