commission formula needing help
 

Hi
I need a formula that works out commission on a cumalitive total which is
worked out in column M

0-25k 7%
25k - 50k 8%
50k - 75k 9%
75k - 150k 10%
150k - 250k 11%
250k - 500k 12%
500k+ 15%

What I have already tried does not work out correctly e.g If the first
invoice was for 30k (cumalitive total in M7) then I need the 1st 25k worked
out on 7% and 5k on 8%. My way works out the total amount on 8%.

Hope I have made myself clear

Any help would be appreciated
Thanks, Amanda

commission formula needing help
 

Hi Amanda,

Look he

http://www.mcgimpsey.com/excel/variablerate.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Amanda" wrote in message ...
| Hi
| I need a formula that works out commission on a cumalitive total which is
| worked out in column M
|
| 0-25k 7%
| 25k - 50k 8%
| 50k - 75k 9%
| 75k - 150k 10%
| 150k - 250k 11%
| 250k - 500k 12%
| 500k+ 15%
|
| What I have already tried does not work out correctly e.g If the first
| invoice was for 30k (cumalitive total in M7) then I need the 1st 25k worked
| out on 7% and 5k on 8%. My way works out the total amount on 8%.
|
| Hope I have made myself clear
|
| Any help would be appreciated
| Thanks, Amanda
|

commission formula needing help
 

Thanks Niek
I have looked at the website you gave me and I am now totally confused. I
am fairly new to this sort of thing. Is there not a single formula that can
work this out instead of using a table? I do not know where to begin. Sorry
for me sounding a bit thick!
Kind regards
Amanda


"Niek Otten" wrote:

Hi Amanda,

Look he

http://www.mcgimpsey.com/excel/variablerate.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Amanda" wrote in message ...
| Hi
| I need a formula that works out commission on a cumalitive total which is
| worked out in column M
|
| 0-25k 7%
| 25k - 50k 8%
| 50k - 75k 9%
| 75k - 150k 10%
| 150k - 250k 11%
| 250k - 500k 12%
| 500k+ 15%
|
| What I have already tried does not work out correctly e.g If the first
| invoice was for 30k (cumalitive total in M7) then I need the 1st 25k worked
| out on 7% and 5k on 8%. My way works out the total amount on 8%.
|
| Hope I have made myself clear
|
| Any help would be appreciated
| Thanks, Amanda
|