Weighted average reverse

[Manoj]

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?

LINK TO EXAMPLE FILE

Thanks

[#2]

@Manoj 

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.