Forum Discussion
Solved
How to calculate a weighting with this scenario?
I'm working on a formula for bonus calculation (i.e. incentive program). Ratings for bonuses are calculated with something like this, a 2.0 is 100% bonus, a 1.0 rating is 50% and a 3.0 is 140%. T...
The function VLOOKUP is helpful in this case.
First of all, I prepared the lookup table in Column A to Column C. The value in Column C is used for calculating decimal part of weight.
In order to find the decimal part, I used the formula F2 - INT(F2).
I am not sure if the rating can be less than 1 or greater than 3. But, I think the idea is similar.
Ms. Kuntz
I don't know if I am doing it right.
please see attached file, if this can help.
you can fill any number - say, in column D- 1.43 or in column J- 2.11 ...
thanks
Looks like you've got it too, thanks.