if formula

[33sameer33]

Dears

Please I need your help to put marks based on the range below using if formula.

From	To	Marks
0	5	0
6	10	1
11	15	2
16	20	3
21	25	4
26	30	5
31	35	4
36	40	3
41	45	2
46	50	1
51	55	0

 

[ETAF]

is this too lookup a value and use the table to produce the marks
=INDEX($C$2:$C$12,MATCH(F2,$A$2:$A$12,1))

otherwise not sure what the formula will do
is it to create the table of marks 0 - 5 and 5-0

IF Formula required - dont understand - what the IF will do

whats the expected results

 

[33sameer33]

is this too lookup a value and use the table to produce the marks
=INDEX($C$2:$C$12,MATCH(F2,$A$2:$A$12,1))

otherwise not sure what the formula will do
is it to create the table of marks 0 - 5 and 5-0

IF Formula required - dont understand - what the IF will do

whats the expected results

It works many thanks for your kind support

if there are other ideas I need to know more about them

 

[bosco_yip]

Or,

In G2, formula copied down:

=LOOKUP(F2,A$2:C$12)