F
frostct
I have commission payout levels with four ranges. Each range represents the
total amount of items sold. Each range pays a certain $ of commission
increasing as you go up the scale. The four ranges are: 1-29 pays $65 per
unit, 30-49 pays $75 per unit, 50-99 pays $85 per unit, 100 + pays $95.
SO if AE sells 55 units then commission = $3,895. (Each of the units 1-29
pay $65 each totalling $1885. Units 30-49 pay $75 each totalling $1500.
Units 50-55 pay $85 each totaling $510. Add $1885 + $1500 + $510 = $3,895 in
commission.
How do I generate this formula so I can enter the units sold and a value
then appears?
total amount of items sold. Each range pays a certain $ of commission
increasing as you go up the scale. The four ranges are: 1-29 pays $65 per
unit, 30-49 pays $75 per unit, 50-99 pays $85 per unit, 100 + pays $95.
SO if AE sells 55 units then commission = $3,895. (Each of the units 1-29
pay $65 each totalling $1885. Units 30-49 pay $75 each totalling $1500.
Units 50-55 pay $85 each totaling $510. Add $1885 + $1500 + $510 = $3,895 in
commission.
How do I generate this formula so I can enter the units sold and a value
then appears?