# commission

1. ### Need a tier based commission calculating formula

For a company, a salesperson gets paid the following way entirely in commission: 11% on all sales up to \$100,000 12% on all sales \$100,001 - 175,000 13% on all sales \$175,001 - 250,000 14% on all sales \$250,001 - 375,000 15% on all sales \$375,001+
2. ### Excel Formula to Calculate Values

I have a Excel Document with two tabs. The first tab is a commission log where I calculate the amount of commission payable and the date it was then paid to the person. I then have a second tab for the statistics so it counts how many orders were generated in a particular month (formula...
3. ### conditional formatting

is there a rule I can setup so that the account number in column B highlights in red if I have a word in the description column I that would make it jump out as the incorrect account? like bonus payments go to 6950 and commission payments to 6955. I sometimes accidentally post them to the...
4. ### Help required with formula

Hi, I need help with a formula that works out a commission based on the number of sales you get. The ount of commission you get is tiered dependant on number of sales 1-4 sales = £5 each 5-9 sales = £7.50 each 10+ sales = £12.50 each I have tried using a formula with IF statements but that...
5. ### Multiple IF commands

Hello Freinds, I'm working on a data were in B columns I'm having "Recharge" Or "Transfer". I'm using IF formula to calculate the Transfer commission. If " Recharge" Is there, then the commission should be "0". Can anyone help to get this formula.
6. ### If query

Hello, I would like to know how to create an IF query for multiple criteria. Basically I need to calculate commission based on the following criteria, brand type min margin if the type is used, then look at the sell price the answer to all of these will then need to look to know if what...
7. ### Is Power Query what I need?

I perform a monthly analysis using source data that is over 400K lines of data. Each line contains information like transaction total, commission amount, and commission percentage. Currently, I have to manually remove any lines that fall within certain criteria. For example, if a line has a...
8. ### Splitting commission

<tbody> <tbody> M N O P Q R S I put staff no. in here I have a formula in here when it generates sales person name after entering her staff no. in column M - formula is =INDEX('Staff info'!\$a\$3:\$a\$22,match(\$Q2,'Staff Info'!\$G\$3:\$G\$22,0)) Formula in here for single sales...
9. ### salesman commission calculation

Dear Friends, Calculating Commission: Main sheet: Cells A1 to H5 <tbody> SALESMAN SALESMAN NO BILL NO BILL DATE SOLD AMOUNT PAYMENT RCVD BALANCE DAYS JOHN 20 AF-001 02-04-2018 1000 1000 0 10 JOHN 20 AF-042 14-04-2018 2000 2000 0 20 JOHN 20 AF-050 29-04-2018 3000 2500 500 12 JOHN 20...
10. ### Backwards - calculate required sales volume from desired commission amount on tiered commission structure

Hi there, sorry if this has been answered somewhere else but the closest thread I could find was this one and it's not quite what I need. https://www.mrexcel.com/forum/excel-questions/759322-work-backwards-desired-commission-amount-find-sales-volume.html Real estate agents for a brokerage are...
11. ### Excel if formula

I have a row in excel that calculates commissions. Once the total gets to \$8,000 (B6 in the below example), I want the formula to no longer calculate commission. Commission should be zero. What formula do I put into the B column? Whenever I do an IF formula, I get a circular reference because I...
12. ### Sliding scale commission formula

Hi all, I am not an advanced user of Excel by any means and am struggling to create a formula for calculating sliding scale sales commissions. I'm the manager of a real estate office and require a formula to assist with automatically calculating the commission payable to an agent based on their...
13. ### SumProduct calculation

So I have a convoluted calculation that I need assistance with. I am trying to calculate commission for hair stylists and additional commission for products that they sell. I have no problem with the calculation that I am using for calculating their commission. Here is an example of what I am...
14. ### Interesting Commission Tier Calculator Wrinkle

I've been looking through multiple posts and am familiar with utilizing SUMPRODUCT to calculate commission tiers that pay out different rates based on sales thresholds. As an example: Pay 10% from \$0-\$99; 15% from \$100-\$199; 20% from \$200-\$299 We have a new wrinkle in the comp plans this year...
15. ### Tiered Commission Structure

Hi Community! I need some assistance please. I am trying to create an Excel file that will help me calculate my commissions, but there's an error in the formula I created. Here's our structure: <tbody> # of Members Commission Per Member 0-10 \$3.50 11-30 \$2.00 31-100 \$1.00 >100 .50...
16. ### Auto Populate one table from another

Good Morning I hope you are all well. I'm looking for some help on on designing commission sheets for my sales team. We have a master file for 2019 that lists every commission our company earns in roughly this format Date / Month / Salesman / Invoice No / Customer / Comm £ Each day new deals...
17. ### Calculating a tiered commission

I have tried and tried many ways and cannot get a formula to work. PLEASE HELP! I am setting up a spreadsheet to calculate sales commissions. The tiers are: \$0-\$40,000 @ 50/50 \$40,001-50,000 @ 60/40 \$50,001-\$60,000 @ 70/30 \$60,001-\$70,000 @80/20 \$70,001 & up @ 90% It is cumulative...
18. ### Vlookup / index over multiple tables

hey everyone! Having trouble wraping my head around a formula.. i have 3 tables; <colgroup><col><col><col><col><col><col><col><col span="6"><col><col span="6"></colgroup><tbody> Best Great Good 1 Year 3 - 6 Years 7 Years 1 Year 3 - 6 Years 7 Years 1 Year 3 - 6 Years 7 Years Quote...
19. ### IF conditions returning a % sum

So I'm creating a spreadsheet to track commission pay-out across multiple pools of business. I want to minimize the risk of my staff doing the % sum themselves but I cant figure out how to use the =IF function. The problem I have is that the commission is different based upon what is sold. For...
20. ### Cumulative tiered commission & exclude big deals from cumulative calc

<tbody> Tier Rate Differential Rate 1 0 5% 5% 2 500,001 10% 5% 3 100,0001 15% 5% 4 1,500,001 20% 5% 5 6 Deal 1 Amount 1,000,000 7 Commission =sumproduct((A1:A4<B6)*(B5-A1:A4)*(C1:C4)) =75,000 </tbody> I have a tiered comm calculation using the above...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back