Was wondering if anyone has a solution for this

  • Thread starter Thread starter DEUS
  • Start date Start date
D

DEUS

I am developing a worksheet that has 3 items sold. Each column has
numerical input for an amount that was charged for that item. Th
object of the sheet is to calculate the commision due for the item
sold. The first column, in order to calculate the commision, you hav
to subtract 200, then get 15%, the next column is subtract 25 then 15%
the last column is subtract 100 then 15%. My goal is to have i
tabulate the total commision due, per sale, based on these thre
objects.


I've tried using nested if statements with and statements, however
get a too many arguments error. The problem is that I have to evaluat
each of the three products, take off the appropriate deduction, the
get 15%.

Any help would be appreciated
 
This should show you the right direction

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

it has a part about commissions as well
--

Regards,

Peo Sjoblom


DEUS said:
I am developing a worksheet that has 3 items sold. Each column has a
numerical input for an amount that was charged for that item. The
object of the sheet is to calculate the commision due for the items
sold. The first column, in order to calculate the commision, you have
to subtract 200, then get 15%, the next column is subtract 25 then 15%,
the last column is subtract 100 then 15%. My goal is to have it
tabulate the total commision due, per sale, based on these three
objects.


I've tried using nested if statements with and statements, however I
get a too many arguments error. The problem is that I have to evaluate
each of the three products, take off the appropriate deduction, then
get 15%.

Any help would be appreciated.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
The problem with the link that you gave me is it only examines 1 input.
I have to evaluate what product is sold out of 3, then deduct the right
amount. I have to look at all possible combinations between the three.


Any other help would be appreciated.
 
bump
Click to expand...

Bump, bump, bump, bump. Bump, bump, bump, bump. Bump, bump, bump, bump, bump,
bump, bump, bump. Bump, bump, bump, bump, bump, bump, bump. Bump, bump, bump,
bump. Dump!

Few things are more likely to get your questions ignored than bump BS.
 
I am developing a worksheet that has 3 items sold. Each column has a
numerical input for an amount that was charged for that item. The
object of the sheet is to calculate the commision due for the items
sold. The first column, in order to calculate the commision, you have
to subtract 200, then get 15%, the next column is subtract 25 then 15%,
the last column is subtract 100 then 15%. My goal is to have it
tabulate the total commision due, per sale, based on these three
objects.
Click to expand...
...

Let's say you have entries for each of the products as follows: value of sales
of product A in cell A2, value of sales of product B in cell B2, and value of
saled of product C in cell C2. The commission basis for product A would be
MAX(0,A-200), for product B MAX(0,B2-25), and for product C MAX(0,C2-100). You
could combine these into a single array expression as

IF(A2:C2>{200,25,100),A2:C2-{200,25,100),0)

or

(A2:C2>{200,25,100))*(A2:C2-{200,25,100))

Using the former, your problem reduces to the array formula

=SUM(IF(A2:C2>{200,25,100),A2:C2-{200,25,100),0))*0.15
 
Back
Top