I need to advice on how to create a formulae to calculate in Excel commission according to different brackets?

Commsion structure is as follows;

Weekly Sales Commission
0 - 19 £10.00
20 - 24 £13.00
25 - 32 £15.00
33 - 39 £16.00
40 - 49 £17.00
50 + £17.50

Answers:
You need to "nest" a series of "IF functions." The formula (assuming sales are in cell D4) follows. The formula should be all in one cell with no spaces between any of the terms.

=IF(D4<=19,10,IF(D4<=24,13,
IF(D4<=32,15,IF(D4<=39,16,
IF(D4<=49,17,17.5)))))

The answers post by the user, for information only, BAnswer.com does not guarantee the right.


More Related Questions and Answers...
  • 3 UNIT Turnkey Rental. What does the term TurnKey mean in this?
  • Where can I find a graphic design internship for my husband in Los Angeles?
  • How much does Best Buy pay (NJ) ?
  • How can I get information on companies in the US? We have Companies House in the UK, what's the US equivalent
  • Taxes in the UK?
  • Are there any funeral or cremation service companies that are publicly traded?
  • Do you believe in your dreams?
  • •Commentators tell us that we should put tariffs on or prohibit the import of goods that are produced under s
  • 'how will u plan various activities in organisation as manager". where will i find any notes to the above Q.