margin

Good Evening I am trying to call a code when a value appears in a column. I am trying the code below, but it works every time the value appears. I just want to call the code once if, say "4W" appears in the column. "4W" may appear multiple times in the column. Is there some way to return a True...

I am building an Income Statement using PowerPivot. I have calculated rows for Gross Margin and Net Income. I want to add a row for Gross Margin %. i.e.: I currently have as a running total: Revenue - Costs = Gross Margin I want to add the following Percentage as a row: Gross Margin % = Gross...

I have gross sales cost and margin in a pivot table and want to show the margin %. I do have the margin % at line level in my data set but bringing this in it adds up all my margin %'s so gives incorrect data. I could create a calculated field in the pivot table I suppose but I thought I'd...

Hi, Please, can someone help me with an Excel formula for finding a Selling Price calculation based on known margin required & Cost Price (Ex. VAT)? Thanks Thanks

Hello, I'm having trouble trying to display results from a different sheet where my raw data is when I try to combine two COUNTIFs. The 1st one works and gives the correct value but when I try to add the 2nd I get an incorrect result. I want a total of when the value in the 1st column is...

Hi, I need to find a solution to the problem below, example, we have 2 companies, Company 1 buys in a product for £35 The sales price of this product is set at £75 for both company 1 and company 2. The question is what is the formula (to achieve the sales price to company 2) so that both...

Hello, I'm new to writing macros and have not been able to make much headway using online instructions or youtube. I have a few hundred excel files, each containing 3 worksheets. I'd like to pull data from a specific worksheet called "Physician Results" and have the data compiled into a single...

Hi All, I'm trying to print PDF files from a specific sheet within excel. The below code works perfectly on a Windows machine but I can't get it working on my Mac. Everytime I run, I get an error code (1004). Do I need to edit the code to be compatible with Mac OS? Can anyone spot any glaring...

Hello, My manager asked me to prepare a margin calculation sheet that contains confidential unit costs and limit its distribution to senior management only. The idea is to create an excel file where the cost is read via a Vlookup formula reading for a local file in drive C. So when a senior...

In the attached spreadsheet I need to get to a gross margin percentage in column H that takes into account that the contract value includes 10% sales tax (would like to do this without adding a column that is the contract value without the sales tax.) I got as far as a formula that produces the...

I'm a newbie and have never used macros before. I would like to have the following code repeat until row 245 if anyone can help. Thanks in advance <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo...

Hi All - First time post and it's a bit of a doozy! In the linked image, I'm creating a spreadsheet to help me cost up items for an eBay store. I've given 5 examples (including the formula from each cell of row 4) of how the COG (Cost of Goods), Stationary cost, Postage cost, eBay & PayPal fees...

Hello all, I was recently offered a sales job where the commission rate is based on the profit margin of the sale (specifically, no commission on sales with less than 20% margin, 20-29% margin = 10% commission, 30-32% = 12.5% comm., 33-39% = 15% and 40%+ margin = 18% commission); in trying to...

Hi all I am trying to find a formula for cell A3(sale price) that can be adjusted by entering a percentage in cell A2(margin) which will be the profit made from cell A1(cost price). Also I need 15% added to the value excluding the cost price. For eg A1 - £2.99 A2 - 20% A3 - £3.58 I need to...

Hi all, I'll start by saying I'm relatively new to Excel so many thanks in advance for your help. I'm looking for help in writing a formula which will help me calculate the numbers of units I need to sell per product to hit a specific gross margin target. Details are as follows:- Product #1...

So I have a basic investment analysis sheet that covers revenue, costs, pre-tax profit for 7 years and ends with an NPV that equates to an implicit margin. However I have been asked to create a two input data table to test the sensitivity of 2 variables in the project. I did that and have a...

Hi, Hope somebody can help with the below formula, the 1st, 3rd and 4th columns we fill in. I have set up formula's to work out the next 3. I'm try to work out the list price, starting at the cost but incorparating the discount and making a 22% margin. The first table works final until you...

Hello, Typically I would grind away for hours trying to solve the problem myself, that way I will never forget how to do it again, but this time, I don't even know where to start! Little confusing to explain, but here is my best shot: In order to keep my table neat, I have the following...

<TBODY> Appreciate it in getting assistance with the Formula in XL2010 for <o:p></o:p> Rate (Sell D11) calculation for different Venders, Products and Sizes.<o:p></o:p> The margins (profit percentage over the cost price) are different<o:p></o:p> for each Vender. The Venders and Products...

XL10 Quotation Margin Auto Calculation Formula <o:p></o:p> Appreciate it in getting assistance with the Formula in XL2010 for <o:p></o:p> Rate (D11) calculation for different Venders, Products and Sizes.<o:p></o:p> The margins (profit percentage over the cost price) are different<o:p></o:p> for...