Help with my table - conditions

[poshgaffer]

Dear All,

Please have a look at the following table. In the 2007/2008 tab or table two I have some formulae problems.

I want to take the sales value in B17 & apply it to the following commission scheme.

Whatever amount of sales the person makes I must subtract 4000 to arrive at the net sales figure.

From this net figure. We pay commission of 10% for the first 10,000 of net sales - 25%(B43) & 30% from 10,001 & above - 25%(B44).

I would like the 25% subtracted from these commissions to be inserted into B45.

Can anyone help?

Best wishes,

poshgaffer, Southampton, England

[davesexcel]

something like this?

=B43/0.75-B43+B44/0.75-B44

[Carim]

Hi,

Attached is a slightly improved worksheet ...

HTH
Cheers
Carim

[poshgaffer]

many thanks. Carim, would you know how to reply to the 25% part of the question also?

[Carim]

Hello again,

Have included the 25% bit in cells C43 and C44 filled in yellow ... for you to read the formula ...

HTH
Carim

[poshgaffer]

I don't think that you completely understood. I'll try to make myself understood. I want the 10% of B17 - 25% amount into B43 & the 30% of B17 - 25% amount in B44.

In B45 I would like the sum of B43 & B44 - 25%

So for example is B17 is 6300

B43 should equal 6300 -4000 * 10% = 230 then subtract 25% giving 172.50

I would want the 25% that was subtracted ie 57.50 into cell B45

Many thanks..

[davesexcel]

I don't think that you completely understood. I'll try to make myself understood. I want the 10% of B17 - 25% amount into B43 & the 30% of B17 - 25% amount in B44.

In B45 I would like the sum of B43 & B44 - 25%

So for example is B17 is 6300

B43 should equal 6300 -4000 * 10% = 230 then subtract 25% giving 172.50

I would want the 25% that was subtracted ie 57.50 into cell B45

Many thanks..

whats wrong with the formula I gave you??

[Carim]

Hi,
Attached is the correction ...
HTH
Carim