If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Salary Commissions
Employee Commission - I cannot get all 3 formulas to work.
PAYROLL SUMMARY TOTAL SALES FOR THE MONTH 27,000.00 PRODUCTION BONUS LEVEL $11,000.00 $(2,000.00) OVERTIME SALARY PAYABLE Production bonus level $11,000 - $16,000 $0.00 10.0% $- Production bonus level $16,001 - $20,000 $0.00 12.5% $- Production bonus level greater then $20,001 $0.00 15.0% $- TOTAL PRODUCTION BONUS $- |
#2
|
|||
|
|||
Salary Commissions
Bonus: 0
+ iif(level = 11000, 0.1*level, 0) + iif( level 16000, 0.125*(level-16000), 0) + iif( level 20000, 0.15*(level-20000), 0) That is, assuming 12.5% is applied to what exceed 16000$, and 15% to what exceed 20000$. ie, at 15999 the bonus is 1599.90$ and at 16001$, the total bonus is NOT 2000.13$, a bonus increase of 400.23$ for a level increase of 3$, but a total bonus of 1600.15$ Vanderghast, Access MVP "Llerfold" wrote in message ... Employee Commission - I cannot get all 3 formulas to work. PAYROLL SUMMARY TOTAL SALES FOR THE MONTH 27,000.00 PRODUCTION BONUS LEVEL $11,000.00 $(2,000.00) OVERTIME SALARY PAYABLE Production bonus level $11,000 - $16,000 $0.00 10.0% $- Production bonus level $16,001 - $20,000 $0.00 12.5% $- Production bonus level greater then $20,001 $0.00 15.0% $- TOTAL PRODUCTION BONUS $- |
Thread Tools | |
Display Modes | |
|
|