| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help with formula
Let's assume your premium is stored in cell A1, then this formula should
calculate your commission based on the criteria you provided. =MIN(A1,20000)*0.07+MIN(MAX(A1-20000,0),10000)*0.05+MAX(A1-30000,0)*0.04 HTH, Elkar "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help with formula
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help with formula
Thanks alot.
"Elkar" wrote: Let's assume your premium is stored in cell A1, then this formula should calculate your commission based on the criteria you provided. =MIN(A1,20000)*0.07+MIN(MAX(A1-20000,0),10000)*0.05+MAX(A1-30000,0)*0.04 HTH, Elkar "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Hide formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
