Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I still have no clue as to how to create a formula from this problem that I have.
I am looking to create variable commission rates for differing price points. Can I get some Help? If sales amount is equal to or less than $449 then commission is 50% of sales If sales are greater than $449 but equal to or less than $599 then commission is 60% of sales. If sales are greater than $599 but equal to or less than $899 then commission is 70% of sales. If sales are greater than $899 but equal to or less than $1799 then commission is 80% of sales. If sales are greater than $1799 then commission is 90% of sales. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sliding commission rates in excel | Excel Worksheet Functions | |||
Sliding scale commission percentages formulas | Excel Worksheet Functions | |||
Percentage Commission on a sliding scale. | Excel Discussion (Misc queries) | |||
sliding commission calculation | Excel Programming | |||
calculating commission on sliding scale | New Users to Excel |