Forum Discussion
Solved
Calculating percentage increases using a scoring system and a set budget amount
I need to be able to calculate a wage increase on individuals. For each person, I have their score from 7-15 (note that multiple people can have the same score), their current annual rate, and the t...
maybe something like:
= [range of scores]/sum( [range of scores] ) * [Budget Amount]
so if the scores are in B2:B20 and the budget is E1 then
= B2:B20 / sum(B2:B20) * E1
