Reallocating Values Based on Percentages and Weights

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!

Crooza,

Thank you for your reply.

Using your formula then, if B is 100% then 1*.4*24=9.6. However, if the actual score is 100% then it should get the max point value of 24. It is transforming the actual score to the point structure that is giving me difficulty.

That works, except I gave out the wrong instructions. The total points between A and B is 40, but A and B are not capped at 16 and 24. i.e. if A was 100% and B was 0 then all 40 points would go to A (and the total score would be 40).

16 and 24 are actually another layer of weighting the scores. Therefore, A will have a weight of .4 (16/40) and weight of .6 and B will have .6 (24/40) and .4.

I attached a new file for reference.

Sorry for the mix up and thanks again for the help.

Sorry for the delay. Just wanted to say thanks. Your last formula did the trick and I was able to modify it for the different scenarios I had.

Thanks again, really appreciate the help.