Re: Calculating sales commision HELP!!!!!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Or, for a more generic solution, look here:

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

--
Kind regards,

Niek Otten

"Eddy Stan" <EddyStan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6519E83E-C78F-444E-8AEF-0814951EA3F1@xxxxxxxxxxxxxxxx
try this..

A1 Target B1 12000
A2 Sales B2 13150
A3 % B3 109.58%
commission B4 657.5

at b4 put
=IF(B3<=99.99%,B2*3%,IF(AND(B3>=100%,B3<=109.99%),B2*5%,IF(B3>=110%,B2*10%,0)))

"spunkysezza" wrote:


Hi everyone;

I really need help, I've looked everywhere and I can't seem to find
anything that has all that my boss is wanting to do! Typical :rolleyes:


My boss is looking for a formula that will be able to calculate the
following.

Sales Commision by rep

E.G.
3% of sales up to 99.99% $_____
5% of sales up to 100% - 109.99% $______
10% of sales up to 110% - above $______

It will be based on the targets that he sets the reps per month.

If anyone has any ideas I would be so gratefull.

Thanks for taking the time to think my request through

Sarah :confused:


--
spunkysezza
------------------------------------------------------------------------
spunkysezza's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=31921
View this thread:
http://www.excelforum.com/showthread.php?threadid=516475




.

Relevant Pages

  • Re: feverishly
    ... I find something odd about the use of the word "feverishly" in this ... or it could be made by a member of group, using "we" to exclude the boss. ... The first case is setting a target; ... the second reading. ...
    (alt.usage.english)
  • Re: Halls of origination
    ... interesting boss mechanichs. ... I just entered my first random dungeon as a freshly dinged level 85 priest healer and got Halls of Origination. ... We had a druid tank, mitigation seemed ok, but no target marking except for the Hex target so of course dps was everywhere. ...
    (alt.games.warcraft)
  • Re: Macro help
    ... line telling him not to attack the boss. ... I believe pet spells work the same as your own spells in a macro, ... to have the pet cast devour magic on your target. ...
    (alt.games.warcraft)
  • Re: Macro help
    ... line telling him not to attack the boss. ... I believe pet spells work the same as your own spells in a macro, ... to have the pet cast devour magic on your target. ...
    (alt.games.warcraft)
  • Re: Macros - Do I Have This Correct??
    ... the portrait under his - voila i'm healing whoever's getting hit; ... and I'm back on the boss, if the portrait under his is different repeat ... and you will be targetting his target. ...
    (alt.games.warcraft)