commission

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

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

Hello Everyone, I have a question. Anything from $0 - $6.95 has 3% commission and anything above $14.25 has 7% commission. The amounts between $6.95 and $14.25 will get more than 3% but less than 7% (the commissions % should increase as they get closer to $14.25 with them capping out at...

Hi, i've been asked to remove a commission amount from a figure to bring it to net, then add in a different commission amount. I can work out all individually but i'm struggling to put it all into one formula so some help would be great! The numbers i have at the moment are as follows; Gross...

Suppose I have the following data <tbody> Alex 01/07/18 10000 Mike 09/07/18 20000 Alex 13/07/18 35000 Jason 13/11/18 26000 </tbody> Now, I'd like to find the maximum commission earned by a person for a month subject to the condition that for each transaction max commission earned...

I'm trying to design a formula for a commission spreadsheet and can't figure this out. The way it works is that if the salesperson sells up to $60k he gets 15%. If he sells $60k to $65k, he gets 17%. If he sells $65k to $70k he gets 18%. And so on; there are 12 commission levels. What I need...

Link to sheet: https://docs.google.com/spreadsheets/d/1nZs3it5lLQm8onE7KPP-RYfpnpeKivNQMtRvcrYqxmM/edit?usp=sharing I am needing to finish the pay sheet for my sales staff. I am needing to return a certain value in column R if 2 different cells have specific data and needing to return a...

Every quarter, I have to do bonus statements for our sales rep. Part of that includes giving them the detail that make up their sales for the quarter. I have a master spreadsheet that contains all of the information for all of the reps. Normally I filter that for each rep, copy and paste their...

I've seached high and low and cant seem to get this to calculate correctly so i'm hoping someone on here can help figure this out! My company uses a tiered commission system that pays out as follows. $0-500,000 0.91% commission $500,000-800,000 1.35%...

A little background: all I know about excel is self taught so it is pretty basic. I manage a semi-small restoration business. I am looking for help at creating a formula for a new commission plan we are rolling out. The basic: The estimator and project manager are supposed to run jobs at 61%...

Hi... I'm new here and I do Graphic Design. Does anyone know of a formula I can use for a commission structure? Whatever the cost to print is, I need a formula that looks at the value in that cell and calculates the correct commission flat rate or percentage in the commission cell. Printing...

I am trying to get commission values to generate based upon three criteria's: <colgroup><col><col><col span="2"></colgroup><tbody> Employee LPH QA Score DH A 4.6 0.967 37.9 B 3.5 0.951 25.6 C 1.7 0.981 29.2 D 3.4 0.912 37.2 E 7 0.964 15 F 2.1 0.863 20 G 5.5...

Hello, Thanks in advance for your help. I am wondering if this is possible to do. Currently I have a master worksheet with many student names and information about the student. What I need to do is calculate the amount of commission we receive based off the tuition amount and other factors...

<tbody> SAVING A/C COMISSION AMOUNT FD A/C COMISSION AMOUNT 10 0 10 0 25 400 25 400 35 0 35 0 50 400 50 900 65 0 65 0 70 0 70 0 75 400 75 1500 </tbody> THIS SALE COMMISSION TABLE OF BANK 1.) IN FIRST TABLE HOW COMMISSION REFLECT SAME IN "COMMISSION AMOUNT COLUMN" WHEN...

Hi everyone, I'm trying to solve this problem in an easy way. I have a database (1000s+ lines) with lines of sellers ID's and amount of sales over a time period. Each seller has a different commission percentage. I want to calculate the total amount of commission to be paid in one formula. So...

Hi, I know I've done this before - but I can't figure it out again! I'm trying to display commission % rates based on Account Name. Sheet 1: A Column: Account Name Sheet 2: A Column: Account Name to Search Sheet 2: B Column: Corresponding Commission Rates for each account I'd like to...

So, I am trying to determine how best to calculate Tie rates for a commission structure when I know what the total payout should be at 100% achieved? Here is a sample of the tier structures, <colgroup><col><col><col></colgroup><tbody> 0.00% 75.000% 2.00% 75.00% 90.000% 3.00% 90.00%...

Hi, First time i have signed up to a forum, I can't seem to find an answer online, and have spent hours trying to figure this out. I need a spreadsheet that calculates varied rates of commission. If a sales person bills £45,000 (above a target threshold), they will be paid on the following...

Hello All, I am trying to build a spreadsheet to generate sales commission if their production is over a certain amount. For instance, if they produce $1.25mil they get $1.25 per thousand dollars if it below $1.25mil it will be $1 per thousand. So if they do the $1.25mil their commission...

Hi, I am trying to get a result from two variables. Variable 1 is a name, say Ian. Variable two is a number (number of sales). If Ian hits a number of sales, then a certain commission value will be returned. If Ian hits 999 sales, he gets a different commission to 1000 - there are various...