calculating result

[kv.singh]

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.

 

[Peter Bartholomew]

I suggest that the table of required points would be better transposed to form column headers.


For me, the dynamic array formula in cell D7 is

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

 

[p45cal]

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.

 

[kv.singh]

Thanks. Both formula working.