I am stuck... I am trying to rank performance and attrition is one of the metrics I am trying to measure. I have a formula for weighting but the problem is the formul actually sees higher attrition as a good thing.

Here is the formula I have:

D4 is the goal: Less than 8%
D5 is actual attrition: 10%

Attritions weight is 25%

Formula is: (D5/$D$4*25%)

Any help would be appreciated.