Weighted average reverse

1Manoj

New Member
Joined
Jun 24, 2020
Messages
3
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I am calculating weighted average based on BENEFITS (60%) and EFFORTS (40%) and give a total score.

Example table:
CRITERIAWEIGHTAGESCORE
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?

Thanks
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Are you looking for something like this? Assuming data is layout like the above.
=SUMPRODUCT(B2:B3*C2:C3)
 
Upvote 0
Hi,

Welcome to the Board.

What formula are you using in your "Score" col?

In your "Effort" row, I would look at using a formula like =(1- "weightage %") * factor to get your "Score" amount. This way, as "Effort %" goes down the higher the number to calculate your "Score"

FS
 
Upvote 0
Managed to solve this by substracting 10(max scoring number a user can enter) to existing score. This will reverse the scoring affect on the calculations.
 
Upvote 0

Forum statistics

Threads
1,212,928
Messages
6,110,734
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top