• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

if formula

33sameer33

New Member
Dears

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

FromToMarks
050
6101
11152
16203
21254
26305
31354
36403
41452
46501
51550
 

Attachments

ETAF

Member
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
 

Attachments

33sameer33

New Member
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
 
Top