software

Hello,

I am trying create a formula that will calculate commission. I would like a
single formula that will calculate $8.00 for the first 16 sales (sales 1 –
16), $12.00 for the next five sales (sales 17 – 21) and $15.00 for each sale
at 22 or more.

So if I sold 23 units the commission will be $218.00.

The number of units sold will be in cell A1.

Thanks for the help.For what is probably the definitive guide to calculating incremental
commisions, check this website:

www.mcgimpsey.com/excel/variablerate.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;JRquot; wrote:

gt; Hello,
gt;
gt; I am trying create a formula that will calculate commission. I would like a
gt; single formula that will calculate $8.00 for the first 16 sales (sales 1 –
gt; 16), $12.00 for the next five sales (sales 17 – 21) and $15.00 for each sale
gt; at 22 or more.
gt;
gt; So if I sold 23 units the commission will be $218.00.
gt;
gt; The number of units sold will be in cell A1.
gt;
gt; Thanks for the help.
gt;

Another way of putting this is $8/unit, PLUS $4/unit for all units over 16,
PLUS $3/unit for all units over 21:
=8*A1 4*max(0,A1-16) 3*max(0,A1-21)

quot;JRquot; wrote:

gt; Hello,
gt;
gt; I am trying create a formula that will calculate commission. I would like a
gt; single formula that will calculate $8.00 for the first 16 sales (sales 1 –
gt; 16), $12.00 for the next five sales (sales 17 – 21) and $15.00 for each sale
gt; at 22 or more.
gt;
gt; So if I sold 23 units the commission will be $218.00.
gt;
gt; The number of units sold will be in cell A1.
gt;
gt; Thanks for the help.
gt;

yea I looked at that before and it does not answer my question. I am going
to repost, please do not reply so I can get an actual answer from someone.

Thanks

quot;Ron Coderrequot; wrote:

gt; For what is probably the definitive guide to calculating incremental
gt; commisions, check this website:
gt;
gt; www.mcgimpsey.com/excel/variablerate.html
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;JRquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I am trying create a formula that will calculate commission. I would like a
gt; gt; single formula that will calculate $8.00 for the first 16 sales (sales 1 –
gt; gt; 16), $12.00 for the next five sales (sales 17 – 21) and $15.00 for each sale
gt; gt; at 22 or more.
gt; gt;
gt; gt; So if I sold 23 units the commission will be $218.00.
gt; gt;
gt; gt; The number of units sold will be in cell A1.
gt; gt;
gt; gt; Thanks for the help.
gt; gt;

Well, if you had used the technique at the web page that Ron cited, you
would have come up with:

=SUMPRODUCT(--(A1-{0,16,21}gt;0),A1-{0,16,21},{8,4,3})

but since that doesn't answer your question, I'm not sure what you're
looking for...

In article gt;,
JR gt; wrote:

gt; yea I looked at that before and it does not answer my question. I am going
gt; to repost, please do not reply so I can get an actual answer from someone.