Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on a sales commissions template. The bonus structure is as
follows:
over 101% of budget but below 105% of budget, the rep receives a bonus of
1%. If the rep exceeds their budget by 105% and over, the rep receives a 2%
bonus. I've worked out the over 105% budget bonus structure but I'm having
troubles working out the "over 101% but below 105% budget" calculation. Any
help is appreciated.
 
Okay...i forgot to include an important variable. Below 101%, the rep is not
entitled to any bonus. If i use that formula when the rep is at 80% of
budget, a bonus is calculated...
So here's the bonus structure:
Below 101% = no bonus
Between 101% and 105% = 1%
Above 105% = 2%.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simplify my life with if... 4
Printer purchase help and advice 10
PLEASE HELP! Return a Value Using Multiple Sources 4
Trying to multiply data by one cell, based on data of another 3
Graphical Indicator to show if outside budget 5
How do I Return a Value Using Multiple Criteria? 1
Need formula to calculate comission & bonuses 1
Filter Combo Box B based on Combo Box A Selection 4

Back
Top