On Tue, 22 Apr 2008 08:41:03 -0700, frostct
wrote:

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 a 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?

As Biff pointed out, there is a typo in the table I initially posted. The
table should read:

Commission Table
0 0 $65
29 $1,885 $75
49 $3,385 $85
99 $7,635 $95
--ron