• 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.

calculating result

kv.singh

New Member
Competition result conditions (Shown in sheet with yellow colours)
competition result of candidates will be calculated on "Points" shown in col. C

Can any one on this forum help me to provide excel formula to calculate result based on points shown in col O and expected output result
shown in Green colour.
 

Attachments

  • SAMPLE. - Copy.xlsb
    8.7 KB · Views: 6
I suggest that the table of required points would be better transposed to form column headers.

76131
For me, the dynamic array formula in cell D7 is
Code:
= IF(Required>0,
     IF(Required<=Points, "QUALIFIED", Required-Points),
     IF(Points=0, "NOT QUALIFIED FOR ANY MEDAL", ""))
The formula would also work using implicit intersection on older versions of Excel.
 
In D4:=IF($C4>=$O$5,"QUALIFIED",$O$5-$C4)
In E4:=IF($C4>=$O$6,"QUALIFIED",$O$6-$C4)
In F4:=IF($C4>=$O$7,"QUALIFIED",$O$7-$C4)
In G4:=IF($C4>=$O$8,"QUALIFIED",$O$8-$C4)
In H4:=IF($C4>=$O$9,"QUALIFIED",$O$9-$C4)
In I4:=IF(C4<=$O$10,"NOT QUALIFIED FOR ANY MEDAL","")
Now copy D4:I4 down as far as you need.
 
Back
Top