Calculating Accumulative Commission

**poshgaffer** · 06-28-2007, 01:58 PM

Hello,

Could someone help me set up the following please?

Sales figure = x

Sales from Band 1 £0 to £3000 = zero % commission
Sales from Band 2 £3001 to £10000 = 5% commission
Sales from Band 3 £10001 to £25000 = 10% commission
Sales from Band 4 £25001 & above = 25% commission

Many thanks

Poshgaffer

**oldchippy** · 06-28-2007, 04:44 PM

Originally Posted by poshgaffer

Hello,

Could someone help me set up the following please?

Sales figure = x

Sales from Band 1 £0 to £3000 = zero % commission
Sales from Band 2 £3001 to £10000 = 5% commission
Sales from Band 3 £10001 to £25000 = 10% commission
Sales from Band 4 £25001 & above = 25% commission

Many thanks

Poshgaffer

Hi Poshgaffer,

May be this will help?

**poshgaffer** · 06-28-2007, 04:57 PM

Perfect...

Many thanks

Poshgaffer

**oldchippy** · 06-28-2007, 04:58 PM

Glad to help - thanks for the feedback

**poshgaffer** · 06-29-2007, 04:21 AM

Dear Chippy,

I think that there is an error on the 25% bracket. If my sales are say, £27,892 I should get a total commission of £2347.25.

Using the table it reads £6,973

Could you have a look at this please? The 25% is only paid on sales above £25,000.

Kind regards,

poshgaffer