commission

Hello All! Via some google searches, I found a few similar questions answered by you fine people but didn't see my exact question and couldn't tweak on my own. Here is the scenario: Agent has an 80/20 split with the brokerage. If they sell 100000.00 house, they get 3% commission (3000) and...

Ok so I have this formula and it works, however I need it to do a bit more and cant figure it out =IF(S99>2400,13%,8%) so S99 is a cell with an average of money made after so many sales and if sales are an average of $2400 or higher it equals to 13% commission and if not it equals to base...

Good afternoon. I am seeking help with a tiered commission schedule that appears to deviate from everyone else. I have included a document here: https://drive.google.com/file/d/103b0w6uWLwOjTNbm9GGl_EkJMQ2ozcFt/view?usp=sharing The gross commission goes into C2. The Gross Totals has a...

Insert a monthly column for a bonus scheme where if a salesperson equals or exceeds 12% commission for the month then they receive an additional $1,250, (This can be achieved by combining the IF and a VLOOKUP statement.) The % of commission and the amount of bonus on offer will vary every...

Hello. I need help with a tiered commission formula that would pay commissions back to dollar one as the rep reached new tiers. For instance, for sales up to $1,000,000 they get a 3.5% commission. Once they hit $1,000,001, the commissions are 6.00%, and they get paid on the first 1,000,000 an...

Hi guys, I need help. Commission structure: R170 001 - R200 000.00 = 4% on R30 000.00 R200 001 - R250 000.00 = 5% on R80 000.00 R250 001 - R300 000.00 = 6% on R130 000.00 R300 001 - R400 000.00 = 8% on R230 000.00 For example: When the commission gets to R170 000.00 - in the second colum (4%)...

Hi I’m trying to work out an appropriate formula to automatically calculate commission. Our commission structure is below; <tbody> Commission band £12,500 Percentage 0 – 50% 2.5 50 – 75% 5 75 – 100% 10 100 – 150% 15 150 – 200% 20 200% + 30 </tbody> Commission is calculated...

Hello, I need to get the sum & average of a sales rep commission within a given date range. A column dates, B column sales rep id, C column commission. I would enter the starting date in A1 and the ending date in B1, and the sales rep id in C1. And with Excel 2003 I know this is a easy one...

I'm trying to add a commission structure. front and back gross. back gross is paid 10% if the front gross is negative, the you subtract that from the back gross, then multiply x 10% if the front gross is positive then no deduction needed. <style type="text/css"><!--td {border: 1px solid...

Hi, Need formula to calculate sales commissions on incremental value. Thanks

I have posted a similar thread earlier but the formaula I am looking for is now different. I'm looking to create a formula that calculates sales commission from monthly sales achieved. Cell A1 will contain monthly sales achieved. The commission structure is $0-$14,999 - 10% 15k-18k - 20%...

I'm looking to create a formula that calculates sales commission from monthly sales achieved. Cell A1 will contain monthly sales achieved. The commission structure is o 0-2000,0% o 2001-4000,15% (retroactive to dollar 1) o 4001-6000,30% (30% applies to 4001-6000) o 6001+,45% (45%...

Hi All, I am trying to figure out a formula so I can create a calculator for use in my business. I am trying to figure out the calculations needed to net down the commission and find the correct commission & premium amount. Example below: I am the insurer. I have quoted a piece of business to...

First, I wasn't sure of the best way to title this post. Hopefully my description below will be more helpful. I need to come up with a way to use excel to calculate a formula based on the following. If an item cost $360,000.00 the following table below needs to be factored in to figure the...

Hi there Below is a commission tiers based on sales. So if someone makes $550k in sales, the commission will be $135k as per below. That calculation is very manual and I was wondering if a SumProduct function would work here. Excel WorkbookABCDEFG1Sales TiersCommission...

Hi there I’m trying to get a formula that calculates commission based on sales tiers. So in the below example A. B. C. % Commission 1. 0. 250,000. 0.3 2. 250,001. 500,000. 0.21 3. 500,001...

Hoping someone could help me out with a formula or macro to solve my issue. I currently have a list of data that's listed as such <tbody> Name Amount Bob 100 Bob 250 Bob 300 Carl 10 Carl 40 Carl 50 Carl 110 Carl 200 David 1000 </tbody> What I need to do is calculate the...

I am struggling to put a formula together for the below set of inputs: <tbody> Target achievement % payout 90% 0 95% 50% 100% 100% 110% 150% 120% 200% </tbody> So if the target was £1000, and they achieved £900 they get nothing, if they got £1100 they get 150%. I need to know the...

I currently have a spreadsheet that figures commissions based on one of two factors. 1. Mono-line commissions 2. Multi-line commissions I want to add, if possible, a way to divide the commission by 2 if it is a shared commission. This is the formula that I am using...

Formula math logic issue: I know these things: 1. vendor cost 2. desired net margin dollars 3. commission percentage what I don't know and need to determine by formula is: 1. a selling price 2. a value of the commission % (I know the desired percentage, but since I don't know the selling...