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