commision calculation

Hello I am trying to create an excel table to calculate a commission structure. Here is the structure that I am working with: <colgroup><col span="3"><col></colgroup><tbody> £0k to £9k 0% £0.00 £9k - £29999 10% £2,100.00 £30k - £44999 15% £2,250.00 £45k - £59999 20% £3,000.00 £60k+...

Hi, I'm fairly new to Excel and have a basic knowledge of how it works. We pay our people tiered commissions. Tier 1 people receive a 50% on the first $1,600 sales, then 60% for anything above. So if someone has $1,809 sales for the week they would receive $925.40 commission. Anyone have a...

Hi I have been trying to work on a fomula to update a new tiered commission structure on my excel sheet and have been having some issues. D4 is total sales $9500 and under you receive 6% commission Anything over $9500 you recieve 35% commission If you make $10,000 for example... It is...

Hi excel gurus, I have a bit of a dilemma in regards to an IF formula, here is a breakdown of the issue i am facing: I have a commission structure: £0-12,000 = 10% £12,001 – £24,000 = 15% £24,001+ = 20% This is worked out on what we have done in the month – but isn’t as simple as one fixed...

Dear all, I/m fresh in excel, i need some help on the formula calculation:- If a sales person want to claims for the commision. He/she must hit 2 main components for the incentive qualification:- 1) Total Gross sales more than 49.9% of the budget AND 2) Total Net gain more than 50% of the...