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