Put your premium in A1, then:

=0.07*MIN(A1,20000)+(A120000)*0.05*MIN(A1-20000,10000)+(A130000)*0.04*(A1-30000)
--
Gary's Student


"Kentucky Insurance" wrote:

I want to be able to calculate different percentages of a number.
Example:
The premium is $50,000
You get 7% commission of the first $20,000 of premium.
You then get 5% of the next $10,000 of premium.
Then you get 4% of the remaining amount.
We want to set the formula so we can put in any premium or percentages to
automatically calculate.
Thanks,
DeNise