I have a a base cost but need to calcualte the retail cost to allow a 30% commission - what's the formula?
Q. I know the base cost of a product but need to calculate the retail price allowing 30% commission. The commission rate is 30% of the retail price to bring you back down to the base cost. I'd be grateful for the formula please so I can place it into the Excel spreadsheet!
Asked by Sugarlump - Mon May 12 03:22:21 2008 - - 1 Answers - 0 Comments
A. Imagine that, you have a product and the base cost of the product is Rs.90.00 You want to add 30% as margin to the retailer to the base cost. The formula is, (Base cost)+(Rate of commission)/100 x (Base cost) i.e 90+(30)/100 x (90) = 90+27=117 is your retail cost. If you want the commission amount to be 30% on the Maximum Retail price (MRP)then to calculate MRP from the base cost this is the formula . Let the Maximum retail price be X. You know the base cost of your product is Rs.90=00, The formula is, (Base cost)+(Rate of commission)/100 x (MRP) = MRP i.e 90 + (30)/100 x (X) = X 90 + 0.30X = X 90 = 0.7X Therefore X = 90/0.7 = 128.57. So if you have a product of base cost Rs.90.00 then the MRP of that product is Rs.128.57. Further… [cont.]
Answered by Sugur S - Mon May 12 04:30:52 2008
Q. I know the base cost of a product but need to calculate the retail price allowing 30% commission. The commission rate is 30% of the retail price to bring you back down to the base cost. I'd be grateful for the formula please so I can place it into the Excel spreadsheet!
Asked by Sugarlump - Mon May 12 03:22:21 2008 - - 1 Answers - 0 Comments
A. Imagine that, you have a product and the base cost of the product is Rs.90.00 You want to add 30% as margin to the retailer to the base cost. The formula is, (Base cost)+(Rate of commission)/100 x (Base cost) i.e 90+(30)/100 x (90) = 90+27=117 is your retail cost. If you want the commission amount to be 30% on the Maximum Retail price (MRP)then to calculate MRP from the base cost this is the formula . Let the Maximum retail price be X. You know the base cost of your product is Rs.90=00, The formula is, (Base cost)+(Rate of commission)/100 x (MRP) = MRP i.e 90 + (30)/100 x (X) = X 90 + 0.30X = X 90 = 0.7X Therefore X = 90/0.7 = 128.57. So if you have a product of base cost Rs.90.00 then the MRP of that product is Rs.128.57. Further… [cont.]
Answered by Sugur S - Mon May 12 04:30:52 2008
sales commission calculation formula using excel 2007?
Q. Need help in formula for the below sales commission earned Sales Amount= $457986.75 Commission of 2% is payable for the 1st $100,000 of sales. Sales above $100,000 and up to $300,000, a 3% commission is payable. Amount above $300,000 will get a commission of 4%.
Asked by WhatIwonder - Fri Oct 30 08:34:22 2009 - - 2 Answers - 0 Comments
Q. Need help in formula for the below sales commission earned Sales Amount= $457986.75 Commission of 2% is payable for the 1st $100,000 of sales. Sales above $100,000 and up to $300,000, a 3% commission is payable. Amount above $300,000 will get a commission of 4%.
Asked by WhatIwonder - Fri Oct 30 08:34:22 2009 - - 2 Answers - 0 Comments
What is a general formula for commercial real estate brokers earning commission?
Q. Both for leasing a space AND selling it. For example: Say I am a broker and lease an office space for 3 yrs, it is 2000 sqm and is 30 per sqm. Would I get commision say 2% on the first month only? or three years? or 36 months?
Asked by bazza - Sun Aug 31 08:06:41 2008 - - 1 Answers - 0 Comments
A. 10% is the standard commission, both leasing and selling.
Answered by Landlord - Sun Aug 31 08:19:41 2008
Q. Both for leasing a space AND selling it. For example: Say I am a broker and lease an office space for 3 yrs, it is 2000 sqm and is 30 per sqm. Would I get commision say 2% on the first month only? or three years? or 36 months?
Asked by bazza - Sun Aug 31 08:06:41 2008 - - 1 Answers - 0 Comments
A. 10% is the standard commission, both leasing and selling.
Answered by Landlord - Sun Aug 31 08:19:41 2008
Commission Formula in Excel?
Q. I am trying to write a Commission Formula in Excel to calculate the Sales Commission based on this criteria: Monthly Sales $0-50K => 3% Commission Monthly Sales >$50K => 6% However, when Accumulative Sales Adds up to $1000,000/ Year Cycle or over, then the Commission become flat ==> 8% Commission. For example: in the 8th month the Monthly Sale = $120K, and by making this sale the Accumulative Sales adds up to $1280,000 How can I bulld an Commision Formula in Excel to Calculate all this possibilities. thank you all, please write me back if you are sure of your answer.
Asked by Karim - Tue Sep 2 20:09:15 2008 - - 3 Answers - 0 Comments
A. There are a number of different ways you can do this. Here's how to do it with nested IF formulas: Assuming that your list of monthly sales is in column A, starting in A1: This formula will check if the sum of the monthly sales column has reached 1000,000. If it has, it results in 0.08. Otherwise if A1 > 5000 it will return 0.06, or if A1 is over 0 it will result in 0.03. If all else fails it will result in zero. =IF(SUM($A$1:A1)>=1000, 0.08, IF(A1>5000, 0.06, IF(A1>0, 0.03, 0))) If the SUM() formula to find the accumulative sales won't work (say if the formula needs to be smart enough to start fresh each January or something) then message me when you add additional details and I'll see about tweaking the formula.
Answered by Sarah M - Tue Sep 2 23:53:10 2008
Q. I am trying to write a Commission Formula in Excel to calculate the Sales Commission based on this criteria: Monthly Sales $0-50K => 3% Commission Monthly Sales >$50K => 6% However, when Accumulative Sales Adds up to $1000,000/ Year Cycle or over, then the Commission become flat ==> 8% Commission. For example: in the 8th month the Monthly Sale = $120K, and by making this sale the Accumulative Sales adds up to $1280,000 How can I bulld an Commision Formula in Excel to Calculate all this possibilities. thank you all, please write me back if you are sure of your answer.
Asked by Karim - Tue Sep 2 20:09:15 2008 - - 3 Answers - 0 Comments
A. There are a number of different ways you can do this. Here's how to do it with nested IF formulas: Assuming that your list of monthly sales is in column A, starting in A1: This formula will check if the sum of the monthly sales column has reached 1000,000. If it has, it results in 0.08. Otherwise if A1 > 5000 it will return 0.06, or if A1 is over 0 it will result in 0.03. If all else fails it will result in zero. =IF(SUM($A$1:A1)>=1000, 0.08, IF(A1>5000, 0.06, IF(A1>0, 0.03, 0))) If the SUM() formula to find the accumulative sales won't work (say if the formula needs to be smart enough to start fresh each January or something) then message me when you add additional details and I'll see about tweaking the formula.
Answered by Sarah M - Tue Sep 2 23:53:10 2008
Does anyone know what the "lehman formula" is for commission rates?
Q. Does anyone know what the "lehman formula" is for commission rates?
Asked by ramsun - Wed Jul 4 12:04:05 2007 - - 1 Answers - 0 Comments
A. It is for investment banking and the commission is a percentage of the deposit that is paid to the banker. The percentage decreases as the deposit increases. The percentage is 5% for the first million dollars deposited, 4% for the second, 3% for the third, 2% for the fourth and 1% for each million thereafter. There are also variations of the formula in use.
Answered by Zarnev - Wed Jul 4 13:59:25 2007
Q. Does anyone know what the "lehman formula" is for commission rates?
Asked by ramsun - Wed Jul 4 12:04:05 2007 - - 1 Answers - 0 Comments
A. It is for investment banking and the commission is a percentage of the deposit that is paid to the banker. The percentage decreases as the deposit increases. The percentage is 5% for the first million dollars deposited, 4% for the second, 3% for the third, 2% for the fourth and 1% for each million thereafter. There are also variations of the formula in use.
Answered by Zarnev - Wed Jul 4 13:59:25 2007
How to calculate commision in excel? (using different commission rates)?
Q. Commissions= Sales x rate of commissions. I have to calculate commissions earned in excel & there is a table which shows the amount of unit sold with different commission rate. Is there a way that I can enter only one formula and apply to others instead of making a commission formula for each column? pls help thanks! no? but what if I have many months to calculate? :( can you for example? Q: 0-120 units, commission rate 6% 121-200 units , 9% commission
Asked by gladcloud1224 - Sun Feb 24 15:20:31 2008 - - 4 Answers - 0 Comments
A. I think you can do what you want using VLOOKUP. First, you need to make sure your table is formatted properly. What you need to do is give the smallest possible value for each commission rate. So, for your example where 0 - 120 is 6% and 121-200 is 9%, your table would have two rows (here the columns are separated by semicolons): 0; .06 121; .09 Then, you create a VLOOKUP formula to look up the appropriate value. In this example, your table is in cells A1 to B2 and the value that you are looking up in the table (the sales amount) is in cell D1. You'll have to replace those cell references with the actual cells in your spreadsheet. =VLOOKUP(D1, $A$1:$B$2, 2, TRUE) The dollar signs in the cell references for the table mean… [cont.]
Answered by Anna M - Tue Feb 26 16:44:34 2008
Q. Commissions= Sales x rate of commissions. I have to calculate commissions earned in excel & there is a table which shows the amount of unit sold with different commission rate. Is there a way that I can enter only one formula and apply to others instead of making a commission formula for each column? pls help thanks! no? but what if I have many months to calculate? :( can you for example? Q: 0-120 units, commission rate 6% 121-200 units , 9% commission
Asked by gladcloud1224 - Sun Feb 24 15:20:31 2008 - - 4 Answers - 0 Comments
A. I think you can do what you want using VLOOKUP. First, you need to make sure your table is formatted properly. What you need to do is give the smallest possible value for each commission rate. So, for your example where 0 - 120 is 6% and 121-200 is 9%, your table would have two rows (here the columns are separated by semicolons): 0; .06 121; .09 Then, you create a VLOOKUP formula to look up the appropriate value. In this example, your table is in cells A1 to B2 and the value that you are looking up in the table (the sales amount) is in cell D1. You'll have to replace those cell references with the actual cells in your spreadsheet. =VLOOKUP(D1, $A$1:$B$2, 2, TRUE) The dollar signs in the cell references for the table mean… [cont.]
Answered by Anna M - Tue Feb 26 16:44:34 2008
I am trying to develop a tiered commission plan. My Excel formula returns a #VALUE! in the cell. Thoughts?
Q. My formula is for total annual sales, where cell B3 is 251000 and the formula is =IF(B3>25000,((B3-5000)*0 .11)+(5000*0.1)+(5000*0.0 9)+(3000*0.08)+(3000*0.07 )+(6000*0.05)+(3000*0.04) ),IF(B3>2000,((B3-2000)*0 .1)+(5000*0.09)+(3000*0.0 8)+(3000*0.07)+(6000*0.05 )+(3000*0.04)),IF(B3>1500 0,((B3-15000)*0.09)+(3000 *0.08)+(3000*0.07)+(6000* 0.05)+(3000*0.04)),IF(B3> 12000,((B3-12000)*0.08)+( 3000*0.07)+(6000*0.05)+(3 000*0.04)),IF(B3>9000,((B 3-9000)*0.07)+(6000*0.05) +(3000*0.04)),IF(B3>6000, ((B3-6000)*0.05)+(3000*0. 04)). I have minimized my parentheses to get rid of the formula errors, but now #VALUE!
Asked by Commissioner - Thu Feb 1 19:04:35 2007 - - 3 Answers - 0 Comments
A. You formula is overly complex when it doesn't need to be. Try to simplify the formula first. For example, you have 5 "IF" conditions. Just looking at the first IF condition, you have the following calculation when TRUE: (( B3-5000) *0.11) +(5000 *0.1)+ (5000 *0.09) +(3000 *0.08) +(3000 *0.07) +(6000 *0.05) +(3000 *0.04)) You would get the exact same result using this calculation when TRUE: (B3-5000) *0.11) +182000) My point is this; simplify your calculations first. It will then become far easier to pinpoint cause of #VALUE error. All I did was perform the static calculations (the ones where numbers never change) and came up with 182000. Do the same for each of your IF conditions. You find out you formula is just too long or… [cont.]
Answered by qwertykph - Fri Feb 2 08:44:16 2007
Q. My formula is for total annual sales, where cell B3 is 251000 and the formula is =IF(B3>25000,((B3-5000)*0 .11)+(5000*0.1)+(5000*0.0 9)+(3000*0.08)+(3000*0.07 )+(6000*0.05)+(3000*0.04) ),IF(B3>2000,((B3-2000)*0 .1)+(5000*0.09)+(3000*0.0 8)+(3000*0.07)+(6000*0.05 )+(3000*0.04)),IF(B3>1500 0,((B3-15000)*0.09)+(3000 *0.08)+(3000*0.07)+(6000* 0.05)+(3000*0.04)),IF(B3> 12000,((B3-12000)*0.08)+( 3000*0.07)+(6000*0.05)+(3 000*0.04)),IF(B3>9000,((B 3-9000)*0.07)+(6000*0.05) +(3000*0.04)),IF(B3>6000, ((B3-6000)*0.05)+(3000*0. 04)). I have minimized my parentheses to get rid of the formula errors, but now #VALUE!
Asked by Commissioner - Thu Feb 1 19:04:35 2007 - - 3 Answers - 0 Comments
A. You formula is overly complex when it doesn't need to be. Try to simplify the formula first. For example, you have 5 "IF" conditions. Just looking at the first IF condition, you have the following calculation when TRUE: (( B3-5000) *0.11) +(5000 *0.1)+ (5000 *0.09) +(3000 *0.08) +(3000 *0.07) +(6000 *0.05) +(3000 *0.04)) You would get the exact same result using this calculation when TRUE: (B3-5000) *0.11) +182000) My point is this; simplify your calculations first. It will then become far easier to pinpoint cause of #VALUE error. All I did was perform the static calculations (the ones where numbers never change) and came up with 182000. Do the same for each of your IF conditions. You find out you formula is just too long or… [cont.]
Answered by qwertykph - Fri Feb 2 08:44:16 2007
I want to sell a home for 200k after paying a 6% commission. How much does the sales price need to be?
Q. I would like to remember for example... Client says they must walk with $200k for sale of home and I would like to add my commission (6%) on top of that ... What is the formula for arriving at what the sale price should be. It is not simply adding 6% to the sale price. Thanks.
Asked by n2hu - Mon Feb 25 12:43:42 2008 - - 9 Answers - 0 Comments
A. The math problem would say that a price of $212,765 would do it. The reality is that it won't work as a list price. You also have to figure in all of the closing costs that seller's are responsible for. Once you've done that you also have to figure in what the average list-to-sold ratio is in your area and pad it just a touch. If the average list-to-sold ratio is 95%, then you need to go a little lower to cover your butt during negotiations. You will need to list close to $230,000 for it to net out at $200,000! Now you can check and see if the home is still at a good price, because if it isn't priced right, it won't sell at all. good luck!
Answered by Rush is a band - Mon Feb 25 15:11:31 2008
Q. I would like to remember for example... Client says they must walk with $200k for sale of home and I would like to add my commission (6%) on top of that ... What is the formula for arriving at what the sale price should be. It is not simply adding 6% to the sale price. Thanks.
Asked by n2hu - Mon Feb 25 12:43:42 2008 - - 9 Answers - 0 Comments
A. The math problem would say that a price of $212,765 would do it. The reality is that it won't work as a list price. You also have to figure in all of the closing costs that seller's are responsible for. Once you've done that you also have to figure in what the average list-to-sold ratio is in your area and pad it just a touch. If the average list-to-sold ratio is 95%, then you need to go a little lower to cover your butt during negotiations. You will need to list close to $230,000 for it to net out at $200,000! Now you can check and see if the home is still at a good price, because if it isn't priced right, it won't sell at all. good luck!
Answered by Rush is a band - Mon Feb 25 15:11:31 2008
What is the formula that can be used for if total is <=200 give 10%, >200 but <= 500 give15%, > 500 give 20%
Q. I want to working out the commission for clients to be calculated as a percentage of their sales using Excel and I am trying to find a formula to work out the commission. I am look for a formula to be used in excel to work out the commission for clients using this criteria: if quantity is <=200 give 10%, >200 but <=500 give 15%, >500 give 20%.
Asked by celah - Wed Jan 30 02:13:15 2008 - - 1 Answers - 0 Comments
A. If your quantity is in cell A2 on your Excel worksheet, then the formula would be: =IF(A2<=200,10%,IF(A2<=50 0,15%,20%)) Boom! Who da man? ;-) If you have Quantity in a different cell than A2, then just change A2 in the formula (in both places) to the cell coordinates where you put Quantity.
Answered by racerj - Wed Jan 30 02:36:45 2008
Q. I want to working out the commission for clients to be calculated as a percentage of their sales using Excel and I am trying to find a formula to work out the commission. I am look for a formula to be used in excel to work out the commission for clients using this criteria: if quantity is <=200 give 10%, >200 but <=500 give 15%, >500 give 20%.
Asked by celah - Wed Jan 30 02:13:15 2008 - - 1 Answers - 0 Comments
A. If your quantity is in cell A2 on your Excel worksheet, then the formula would be: =IF(A2<=200,10%,IF(A2<=50 0,15%,20%)) Boom! Who da man? ;-) If you have Quantity in a different cell than A2, then just change A2 in the formula (in both places) to the cell coordinates where you put Quantity.
Answered by racerj - Wed Jan 30 02:36:45 2008
What is the excel formula for figuring out a percentage?
Q. I have a currency figure in A1 and a commission amount in A2, how do i calculate what percentage A2 is of A1? Thank you!
Asked by JJ - Wed Jul 30 17:36:20 2008 - - 3 Answers - 0 Comments
A. In cell A1: type your currency In cell A2: type the commission value In cell A3: type "=A2/A1" (without quote) then hit Enter In cell A3: right click then select Format Cells In Format Cells window: select Number tab. In Number tab: select Percentage option then click OK button or visit my blog at excel-tutorial-video.blog spot.com to see more illustration (with different metode in apply percentage)
Answered by vijay - Fri Aug 1 02:06:01 2008
Q. I have a currency figure in A1 and a commission amount in A2, how do i calculate what percentage A2 is of A1? Thank you!
Asked by JJ - Wed Jul 30 17:36:20 2008 - - 3 Answers - 0 Comments
A. In cell A1: type your currency In cell A2: type the commission value In cell A3: type "=A2/A1" (without quote) then hit Enter In cell A3: right click then select Format Cells In Format Cells window: select Number tab. In Number tab: select Percentage option then click OK button or visit my blog at excel-tutorial-video.blog spot.com to see more illustration (with different metode in apply percentage)
Answered by vijay - Fri Aug 1 02:06:01 2008
How do I write the formula for this?
Q. Tina has a job selling laptop computers. Her weekly salary is $300 plus a $25 commission for each computer that sells after the first 5. Trust me, the formula isn't the answer to the problem. (Just love 6-step problems. Don't you?) How do I find the formula to this? P.s. It is not y=300 + 25x for those of you who thought it was. Thanks in advance.
Asked by Ahnrya - Mon May 25 21:08:22 2009 - - 1 Answers - 0 Comments
A. *sorry, i dont know how to type/insert the "greater than or equal" symbol* when x > 4 y = 25(x-5) + 300 when -1 < x < 5 y = 300
Answered by achaminadefriend - Wed May 27 10:26:33 2009
Q. Tina has a job selling laptop computers. Her weekly salary is $300 plus a $25 commission for each computer that sells after the first 5. Trust me, the formula isn't the answer to the problem. (Just love 6-step problems. Don't you?) How do I find the formula to this? P.s. It is not y=300 + 25x for those of you who thought it was. Thanks in advance.
Asked by Ahnrya - Mon May 25 21:08:22 2009 - - 1 Answers - 0 Comments
A. *sorry, i dont know how to type/insert the "greater than or equal" symbol* when x > 4 y = 25(x-5) + 300 when -1 < x < 5 y = 300
Answered by achaminadefriend - Wed May 27 10:26:33 2009
A realtor receives a commission of $1O,120 for selling a house. What is the selling price?
Q. Real Estate commission. The following is a typical real estate commission on the selling price of a house: 7% for the first $100,000 and 4% for the amount that exceeds $100,000. A realtor receives a commission of $10,120 for selling a house. What was the selling price? I am not just looking for an answer here, I would like an explanation as how to figure out a math word problem like this. I know the answer is $178,000 but I'm not sure of the steps or formula to use to get there. I have struggled to do this problem a few ways, with no success, any help or suggestions?
Asked by Kris S - Tue Jan 9 20:56:36 2007 - - 8 Answers - 0 Comments
A. First make a note of the things you know and the things you don't know: You know that it's a fixed 7% of 100,000 You know that the total commission is 10,120 What you need to know is the amount over 100,000 that the 4% commission is applied to so call that amount x. Start writing down these things in a equation: Total Commission = 7% of 100,000 + 4% of the amount over 100,000 Restated with numbers and variables: 10,120 = 7% * 100,000 + 4% * x 10,120 = .07 * 100,000 + .04x 10,120 = 7000 + .04x 10,120 - 7000 = .04x 3120 = .04x 3120/.04 = x 78,000 = x Remember that x is the amount over 1000 so you have to add that to the 78,000 to get 178,000.
Answered by huskie - Tue Jan 9 21:07:42 2007
Q. Real Estate commission. The following is a typical real estate commission on the selling price of a house: 7% for the first $100,000 and 4% for the amount that exceeds $100,000. A realtor receives a commission of $10,120 for selling a house. What was the selling price? I am not just looking for an answer here, I would like an explanation as how to figure out a math word problem like this. I know the answer is $178,000 but I'm not sure of the steps or formula to use to get there. I have struggled to do this problem a few ways, with no success, any help or suggestions?
Asked by Kris S - Tue Jan 9 20:56:36 2007 - - 8 Answers - 0 Comments
A. First make a note of the things you know and the things you don't know: You know that it's a fixed 7% of 100,000 You know that the total commission is 10,120 What you need to know is the amount over 100,000 that the 4% commission is applied to so call that amount x. Start writing down these things in a equation: Total Commission = 7% of 100,000 + 4% of the amount over 100,000 Restated with numbers and variables: 10,120 = 7% * 100,000 + 4% * x 10,120 = .07 * 100,000 + .04x 10,120 = 7000 + .04x 10,120 - 7000 = .04x 3120 = .04x 3120/.04 = x 78,000 = x Remember that x is the amount over 1000 so you have to add that to the 78,000 to get 178,000.
Answered by huskie - Tue Jan 9 21:07:42 2007
Mr. Triber earns a weekly salary of $300 plus 10% commission on all sales. If he sold $8,350 last week, what ?
Q. I know this is simple but my brain is fried and its been a long while since I had to do these. Someone please give me the breakdown not looking for the answer out right just formula thank you. Mr. Triber earns a weekly salary of $300 plus 10% commission on all sales. If he sold $8,350 last week, what were his total earnings
Asked by Julian M - Tue Feb 3 21:44:47 2009 - - 2 Answers - 0 Comments
A. To get 10% of something you multiply it by 10% as a decimal, which is 0.10. So the formula is : 300 + 0.10 8350
Answered by hayharbr - Tue Feb 3 21:48:46 2009
Q. I know this is simple but my brain is fried and its been a long while since I had to do these. Someone please give me the breakdown not looking for the answer out right just formula thank you. Mr. Triber earns a weekly salary of $300 plus 10% commission on all sales. If he sold $8,350 last week, what were his total earnings
Asked by Julian M - Tue Feb 3 21:44:47 2009 - - 2 Answers - 0 Comments
A. To get 10% of something you multiply it by 10% as a decimal, which is 0.10. So the formula is : 300 + 0.10 8350
Answered by hayharbr - Tue Feb 3 21:48:46 2009
Formula to Figure Gain/Loss for 1099B?
Q. I am not going to let this get the best of me. I received my year end or tax documentation today from the company I use to trade. All it states is Gross Proceeds Less Commission (it s basically the amount I deposited into the trading account (it does not break out the gains/losses, commissions or reg. fee). If I use this information as is it look s as if I m the only person in the world who had NO losses last year. I actually only gained about $35.00 when all was said and done. Of course I want to claim the loss. Usually I am able to download my trading information directly into my tax software, but that s not going to be the case this year and I have to manually enter the information. You would think that would be simple enough. [cont.]
Asked by Miz Patti - Wed Jan 28 23:16:18 2009 - - 2 Answers - 0 Comments
A. Good job. You are on the right track! You are perfectly correct to use the number for cost basis (= price*shares + buy commission) and the number for proceeds (=price*shares - sell commission) that you identify in your question. Richard K Master Tax Advisor HR Block This advice was prepared based upon the law in effect at the time it was written as it applies to the facts provided by you. See my profile for more information.
Answered by hrblockrichardk - Wed Jan 28 23:31:32 2009
Q. I am not going to let this get the best of me. I received my year end or tax documentation today from the company I use to trade. All it states is Gross Proceeds Less Commission (it s basically the amount I deposited into the trading account (it does not break out the gains/losses, commissions or reg. fee). If I use this information as is it look s as if I m the only person in the world who had NO losses last year. I actually only gained about $35.00 when all was said and done. Of course I want to claim the loss. Usually I am able to download my trading information directly into my tax software, but that s not going to be the case this year and I have to manually enter the information. You would think that would be simple enough. [cont.]
Asked by Miz Patti - Wed Jan 28 23:16:18 2009 - - 2 Answers - 0 Comments
A. Good job. You are on the right track! You are perfectly correct to use the number for cost basis (= price*shares + buy commission) and the number for proceeds (=price*shares - sell commission) that you identify in your question. Richard K Master Tax Advisor HR Block This advice was prepared based upon the law in effect at the time it was written as it applies to the facts provided by you. See my profile for more information.
Answered by hrblockrichardk - Wed Jan 28 23:31:32 2009
CAN YOU HELP EXCEL FORMULA?
Q. In one excel cell the input is : Yes , No, NA (drop down menu), say Cell : L242 In another cell the value is amount( loan amount). say Cell : H8 My requirement is to insert formula to calculate the commission in Cell , say in Cell L 243, if the L242 is Yes, than if the loan amount is equal to or less than 2000 ,0% of H8, if the loan amount is more than 2000 upto 5000, 1.00% of H8, if the loan amount is more than 5000 , 1.5% of H8. Where the input in L242 is not Yes, the value if amount in cell L243 should be 0(zero), not the message : False. Please help for formula
Asked by sail - Thu Aug 21 22:53:36 2008 - - 1 Answers - 0 Comments
A. I'm going to restate your rproblem to be sure it's what you meant, and give the formula. If you find that it's not what you wanted, it should be pretty easy to adjust. It's nested IFs with a couple of ANDs. L242 values are "Yes", "No", or "NA" H8 value is the loan amount L243 will hold your formula to calculate commission. The commission rules are as follows: If L242 is Yes and H8 > 5000 then the commission is .015*H8 If L242 is Yes and 2000 < H8 <= 5000 then the commission is .01*H8 If L242 is Yes and H8 < = 2000 then the commission is 0 If L242 is not Yes, then the commission is 0 In order to show the whole formula here, I have to carriage return. You would just have everything together. (Copy each line to something else and get… [cont.]
Answered by conehead - Fri Aug 22 00:14:45 2008
Q. In one excel cell the input is : Yes , No, NA (drop down menu), say Cell : L242 In another cell the value is amount( loan amount). say Cell : H8 My requirement is to insert formula to calculate the commission in Cell , say in Cell L 243, if the L242 is Yes, than if the loan amount is equal to or less than 2000 ,0% of H8, if the loan amount is more than 2000 upto 5000, 1.00% of H8, if the loan amount is more than 5000 , 1.5% of H8. Where the input in L242 is not Yes, the value if amount in cell L243 should be 0(zero), not the message : False. Please help for formula
Asked by sail - Thu Aug 21 22:53:36 2008 - - 1 Answers - 0 Comments
A. I'm going to restate your rproblem to be sure it's what you meant, and give the formula. If you find that it's not what you wanted, it should be pretty easy to adjust. It's nested IFs with a couple of ANDs. L242 values are "Yes", "No", or "NA" H8 value is the loan amount L243 will hold your formula to calculate commission. The commission rules are as follows: If L242 is Yes and H8 > 5000 then the commission is .015*H8 If L242 is Yes and 2000 < H8 <= 5000 then the commission is .01*H8 If L242 is Yes and H8 < = 2000 then the commission is 0 If L242 is not Yes, then the commission is 0 In order to show the whole formula here, I have to carriage return. You would just have everything together. (Copy each line to something else and get… [cont.]
Answered by conehead - Fri Aug 22 00:14:45 2008
I need a formula in excel for commissions. Up to $999=1%. $1,000. to $2,999.= 2%. $3,000-$5,999.=3%.?
Q. I need a formula in excel for commissions. Up to $999=1%. $1,000. to $2,999.= 2%. $3,000-$5,999.=3%.?
Asked by Wendy - Wed Apr 29 12:42:10 2009 - - 1 Answers - 0 Comments
Q. I need a formula in excel for commissions. Up to $999=1%. $1,000. to $2,999.= 2%. $3,000-$5,999.=3%.?
Asked by Wendy - Wed Apr 29 12:42:10 2009 - - 1 Answers - 0 Comments
Excel percentage formula help ?
Q. I have a table with 3 types of commission a 5%, b 10% and c 15%. I have to reduce the the total of all 3 commissions by 10% by adjusting the commission rate for C. How do I work this out?
Asked by lbaker2656 - Wed Dec 31 13:28:11 2008 - - 2 Answers - 0 Comments
A. Let's assume these percentages were relating to the same amount, lets say $1000? a = $50, b= $100, c= $150. Total = $300 Reducing the total commision by 10% would leave you with 300-30= $270. This equates to a 20% reduction in commision c ($30). Therefore, you would have to reduce the commision rate c (which is 15%) by 20%. 20% of 15 is 3, so you would have to change c to 12%. a 5%, b 10%, c 12%. I hope this is what you meant? Question was a little unclear If this isnt what you want, add more details, i will try and help
Answered by Kamal Gilkes - Wed Dec 31 13:42:20 2008
Q. I have a table with 3 types of commission a 5%, b 10% and c 15%. I have to reduce the the total of all 3 commissions by 10% by adjusting the commission rate for C. How do I work this out?
Asked by lbaker2656 - Wed Dec 31 13:28:11 2008 - - 2 Answers - 0 Comments
A. Let's assume these percentages were relating to the same amount, lets say $1000? a = $50, b= $100, c= $150. Total = $300 Reducing the total commision by 10% would leave you with 300-30= $270. This equates to a 20% reduction in commision c ($30). Therefore, you would have to reduce the commision rate c (which is 15%) by 20%. 20% of 15 is 3, so you would have to change c to 12%. a 5%, b 10%, c 12%. I hope this is what you meant? Question was a little unclear If this isnt what you want, add more details, i will try and help
Answered by Kamal Gilkes - Wed Dec 31 13:42:20 2008
Working out Commission in Excel?
Q. hello i have an excel spreadsheet and i need to work out the commission for the sales for a couple of people. the commission rate is 5% of total sales, but i don't know what to type into Excel to get the right formula e.g. H6*0.05... or something like that
Asked by tom - Mon May 4 00:29:47 2009 - - 3 Answers - 0 Comments
A. you got it. Just need the = sign before it and you don't need the 0 before the decimal point.
Answered by Da Bear - Mon May 4 00:34:25 2009
Q. hello i have an excel spreadsheet and i need to work out the commission for the sales for a couple of people. the commission rate is 5% of total sales, but i don't know what to type into Excel to get the right formula e.g. H6*0.05... or something like that
Asked by tom - Mon May 4 00:29:47 2009 - - 3 Answers - 0 Comments
A. you got it. Just need the = sign before it and you don't need the 0 before the decimal point.
Answered by Da Bear - Mon May 4 00:34:25 2009
I need help translating this homework question?
Q. Enter a formula for John that will figure his commission. The commission rate of 4% is located in cell E13. Be sure to use an absolute reference before filling the forumla down.
Asked by Deep Man - Sun May 6 07:54:27 2007 - - 2 Answers - 0 Comments
A. It should be sales times rate of commission. Input in E12 total sales made by John. Then you should use this formula Round(E12*E13,2). This equation should be entered in cell E15.
Answered by c1523456 - Sun May 6 07:59:16 2007
Q. Enter a formula for John that will figure his commission. The commission rate of 4% is located in cell E13. Be sure to use an absolute reference before filling the forumla down.
Asked by Deep Man - Sun May 6 07:54:27 2007 - - 2 Answers - 0 Comments
A. It should be sales times rate of commission. Input in E12 total sales made by John. Then you should use this formula Round(E12*E13,2). This equation should be entered in cell E15.
Answered by c1523456 - Sun May 6 07:59:16 2007
I m doing a MS excel spread sheet to calculate total commission to my sales people. I could use some help!?
Q. I m doing a MS Excel spreadsheet to show the calculations of total sales commissions to each sales person at a rate of 4.625%. Now my formula must have an absolute reference and should be copied to other cells to illustrate that it works. How do I go about doing this? If you have the free time feel free to email me an actual excel 2003 file showing this to me with all the absolute references. meuntome@yahoo.com Name of Salesperson Sales for Year Mortimer Adler $3,015,082.00 John Dewey $989,872.12 Robert Hutchins $2,105,716.33 John Erskine $2,212,884.41 Elizabeth Wilkins $1,689,414.80 Vikki Spencer $2,716,415.23 Dale Allee $4,212,694.18
Asked by I have a question - Fri Jul 20 11:11:44 2007 - - 2 Answers - 0 Comments
A. I have emailed you a spreadsheet with your request. I hope it works for you.
Answered by Cesare - Fri Jul 20 11:37:11 2007
Q. I m doing a MS Excel spreadsheet to show the calculations of total sales commissions to each sales person at a rate of 4.625%. Now my formula must have an absolute reference and should be copied to other cells to illustrate that it works. How do I go about doing this? If you have the free time feel free to email me an actual excel 2003 file showing this to me with all the absolute references. meuntome@yahoo.com Name of Salesperson Sales for Year Mortimer Adler $3,015,082.00 John Dewey $989,872.12 Robert Hutchins $2,105,716.33 John Erskine $2,212,884.41 Elizabeth Wilkins $1,689,414.80 Vikki Spencer $2,716,415.23 Dale Allee $4,212,694.18
Asked by I have a question - Fri Jul 20 11:11:44 2007 - - 2 Answers - 0 Comments
A. I have emailed you a spreadsheet with your request. I hope it works for you.
Answered by Cesare - Fri Jul 20 11:37:11 2007
From Yahoo Answer Search: 'formula for commission'
Tue Nov 3 15:28:57 2009 [ refresh local cache ]
[Hide]▼
formula1blog.com
(Negative Camber & Grace)
hu, 25 Jun 2009 16:27:29 GM
Luca di Montezemolo shared a few more details of the agreement between the FIA and FOTA that has reduced tension and ostensibly ended the row between the two.
[Hide]▲
