commission formula

Hi, I would like a formula for a commission structure. Say C5 to C16 are months of the year with sales figures per month for which commission is paid. I would like the formula to work out the commission I would get each month. The end of the formula on months after January will then minus the...

Hi guys! Hope all of you are doing well and healthy. I need some help here creating a formula that will help me to calculate the commissions for salespeople based on the tiers below: Tier 1 - Sales Up to $20,000.00 - Not Eligible for Commission Tier 2 - Greater than $20,000.01 up to $50,000.00...

Hi, I require a formula to work out a sales commission structure as a lot of online templates seem to be different structures. In a nutshell, when looking at the picture, I will require 5 of the same formulas which I can replicate which need to go into the cells in yellow in G2, G3, G4, G5 &...

I am having issues creating this formula for a Projected Cash Flow Budget regarding the Commission Sales Payout. Here is the scenario as followed: The first $200,000 = 10% The second $200,000 = 8% Any sales dollar exceeding $400,000 = 7% Lets say our Sales guy sales $280,000 the first month...

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+...

Hey guys. I'm having a lot of trouble with a formula to calculate commissions for my sales team. This is how it works, we have five sales representatives in the team: Sales Rep1 Sales Rep2 Sales Rep3 Sales Rep4 Sales Rep5 Ok. So each one of them has a minimum sales goal monthly. IF they...

Hello, I am trying to build a formula that will enter 0 if the sum of the range of cells selected doesn't agree with the requirements, and if the sum of selected cells does agree with the requirements then it will be multiplied by a certain number. This is for a tiered calculation where there...