I need a formula so all I have to do is enter the commission once
Example:
Commission amount $18,000.00
the first $1.00-$6000 is x by 15% = amount
$6,001 to $14,000x by 20% = amount
$14,000 to $20,000 x 25% = amount

Commission total
Can anyone help me?????