Wow thats an interesting equation. I didnt know Excel could do that kinda
stuff!
If I put in 101 units, I got 227.25 so i dont think its working just right
yet!! Going in the right direction though!!
thanks xgirl!!!
any ideas how to correct that??

dan


"xgirl" wrote:

Dan, try this...

With unit numbers beginning in Cell A2 put this formula in cell B2
=IF(A2<=100,A2*2,IF(A2<=200,A2*2.25,A2*2.5))


"Dan Lieberman" wrote:

Hi Henry.
First option

I need to set it up so i can simply input in how many units this person has
sold in total, and then have the worksheet show me the commissions amounts..

100 units @ $2.00
101- 200 units @ $2.25
201 - 300 units @ $2.50

So all i want to do is input a # and have it tell me how much commission
this person has earned...

please email me direct at if you need to!

Thanks much Henry!!!



"Henry" wrote:

Dan,

Not clear what you want.

Sales of 101 units:

Either 100@ $2.00 +1 @ $2.25 =$202.25

Or 101 @ $2.25 = $227.25

Henry


"Dan Lieberman" <Dan wrote in message
...
Hello!!! Here is what im trying to do!

I am trying to set up a commission scale for promoters that pays them $2
per
unit sold if they sell under 100 units.

If they sell 101 - 200 units id like to pay them $2.25 per unit.
201 - 300 units they get $2.5 per unit

How can I do this in a sensible way that organizes the commissions and
shows
me the sales person's total commissions.