I am having difficulty in coming up with a formula that will assign point values based on a given number of points and the weights assigned to them.
I have two indicators that are assigned a score of 1-100. The scores will be weighted based on criteria and each indicator will be assigned a point value. The criteria/rules for the calculation are:
1. Assume A is weighted at 60% and B at 40%.
2. The maximum point value assigned to A is 16 and the maximum point value for B is 24.
3. Total point value for A+B=40.
i.e. if A and B both receive 100 points then A is assigned 16 points and B is assigned 24 points.
I have attached an example of the layout, but I am struggling with the formulas to make the calculations work.
Thanks you in advance for the help!
Bookmarks