• 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

  • If formula.xlsx
    8.3 KB · Views: 5
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

  • If formula-ETAF.xlsx
    9.3 KB · Views: 3
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
 
Back
Top