Formula between 2 numbers

[fmjen3505]

I would like to create a formula to calculate the following

Sale Amount	Commission
$0 - $10,000	8%
$10,001 - $20,000	6%
$20,001 - $30,000	5%
$30,000 +	3%
EXAMPLE
Sale Amount	Commission
$25,000 job	$1,650	<-- Total
First $10K	$800	8% of $10K
Second $10K	$600	6% of $10K
Remaining $5K	$250	5% of $5K

 

[Z51]

For the total, you could use the following (where sale amount is in A1):

=IF(A1<=10000,A1*0.08,IF(A1<=20000,800+((A1-10000)*0.06),IF(A1<=30000,1400+((A1-20000)*0.05),1900+((A1-30000)*0.03))))

 

[fmjen3505]

Perfect, thank you!