Hi,

You can do like this. You'll get the points and then based on that you can
assign ranks.
In this case, if all goals are met, means actual are same as goal%, sum of
these 5 point values will be 1.

Meas Goal Goal% Weight Actual Points
M-1 = 85 45 70 =IF(B2="=", E2/(C2*100)*D2, C2/(E2*100)*D2)
M-2 = 90 25 60 =IF(B3="=",E3/(C3*100)*D3,C3/(E3*100)*D3)
M-3 <= 25 5 40 =IF(B4="=",E4/(C4*100)*D4,C4/(E4*100)*D4)
M-4 = 95 10 70 =IF(B5="=",E5/(C5*100)*D5,C5/(E5*100)*D5)
M-5 <= 7 15 10 =IF(B6="=",E6/(C6*100)*D6,C6/(E6*100)*D6)


aamerrasheed wrote:
Hi,
Can you please clarify one thing. For M3 and M5, points should be higher if
the actual is less. How to decide the points in this case.
For example for M3 you say, <=25 percent. Now if the actual is 0% or 25% or
50 %, what points do you want to give?

Hi-

[quoted text clipped - 24 lines]
Thanks,
Mayte

--
Message posted via http://www.officekb.com