I am working on an incentive formula and need some ideas.
Incentive is based on linear growth.. variables given below
Salary: 10,000
100% Bonus: 30,000 based on achieving 100% of target
Min Bonus: 50% (or 15,000) based on achieving 95% of target
Max Bonus: 200% (or 60,000) based on achieving 115% or more of the target
Sales component: 75%
AR component: 25%
Paid Quarterly
For the Sales component the amount between 95% and 100%, I was trying to build the formula but am not able to get the result correct.
=AND(97%>=95%,97%<100%)*30,000/4*75%*97%
What am I doing wrong? Note that bonus between 95% and 100% should be a linear growth from 15,000 to 30,000.
Hope someone can help.
Incentive is based on linear growth.. variables given below
Salary: 10,000
100% Bonus: 30,000 based on achieving 100% of target
Min Bonus: 50% (or 15,000) based on achieving 95% of target
Max Bonus: 200% (or 60,000) based on achieving 115% or more of the target
Sales component: 75%
AR component: 25%
Paid Quarterly
For the Sales component the amount between 95% and 100%, I was trying to build the formula but am not able to get the result correct.
=AND(97%>=95%,97%<100%)*30,000/4*75%*97%
What am I doing wrong? Note that bonus between 95% and 100% should be a linear growth from 15,000 to 30,000.
Hope someone can help.
