Forum Discussion
Weighted average reverse
I am calculating weighted average based on BENEFITS (60%) and EFFORTS (40%) and give a total score.
Example table:
| CRITERIA | WEIGHTAGE | SCORE |
| BENEFITS | 60% | 10 |
| EFFORTS | 40% | 1 |
| TOTAL SCORE | 100% | 6.4 |
For EFFORTS I want weighted calculation to be reversed, so, lower number should show increased TOTAL SCORE.
= -(40% * 1) -- do you think adding -ve to the calculation will give to correct score or is there any better formula in excel please?
https://docs.google.com/spreadsheets/d/13Vgydzy0QbCGkMSC4X5Z20GvI4kgVOeoJSzMaVtEKpk/edit?usp=sharing
Thanks
1 Reply
Since it appears that you're expecting the weights to add to 100%, it would appear that the calculation is correct. But is that the case?
And are the numbers under "Score" limited to the range of 1-10? Or can they range more widely. Can they be other than integers?
So, in addition to defining the whole situation a bit more fully, it would help if you could spell out in an example or two what a "correct score" would look like as the "Effort" number goes up or down.
