cost

Hey guys, Long time lurker, first time poster! Need some help if I may, I'm running a dataset for tender airfreight costs for my business, got the results split by country of origin, by weight break (45kg,100kg etc), across 4 carriers and three service levels (Deferred/Standard and Premium) I...

I'm learning INDEX/MATCH & have a little problem with conditional formatting Below example looking at air fares by airline to various destinations, in cell D10 I return the correct cost based on the selections of airline & destination in B10 & C10, it works fine...

Good Morning all, I am working on an Energy calculator and as part of the customer facing end I want to show a graph that shows return on investment. For this graph i need to show the current energy cost along with the savings the client will achieve using our products. The problem i currently...

I have a very basic expense sheet that I cannot figure out how to calculate the total balance column/cells properly. <tbody> Date Client Name Item Description Cost Refund Deposit Balance 3/29/19 Admin Call Deposit $300 $300 4/1/19 Jones Call Cost $86 $214 4/2/19 Jones Call Refund...

Hi Have this formula: =(K12+V12)*F12 K12 is a product cost V12 is a ancillary product cost F12 is the exchange rate from $ to £ I want to add a 5% currency fluctuation surcharge into the calculation , I have 5% written in cell G12 Is there a way I can add to the formula the 5% to the 2...

In VBA I'm trying to copy just the 21 in "Cost Center: 21 - Northern NS" and just the 30, etc, in "Cost Center: 30" as you see below. when I do this in a macro it copies the 21 all the way to the bottom and ignores the 30 and 40, how can I fix this? I tried to tag this, but I received an error...

I have an excel worksheet which has 3 sheets in total. This is the 2nd one. And this is the 1st I want a formula that will automatically take data from 2nd sheet (when I enter a weight in "Enter Weight LB" cell) and paste it on "Shipping Cost" cell by Zone of course. "Your Zone" cell is...

Hi group. Newbie poster here using Excel 2013 I hope you can point me in the right direction. I have a list of base data of that contains a number of columns: Salesperson / Customer / Area / Invoice Num / Date / Item / Qty /Unit sales Price / Line Sales Value / Unit cost / Line cost. I can...

I have 4 columns that need to be combined into 3 new columns Product,revenue,product,cost into a combined product, revenue, cost. The product data does not always have both cost and revenue so a zero will have to be added if product has only one. A $1 A .5 B $2 C .2 D $3 Result A $1 .5...

Hi there, hoping someone can help me sort out a poorly formatted data-set which I've inherited and need to clean up to create some reports. In short, the data-set extends out from column A to column A0, and has 435 rows. Each row shows a unique 'case number' and then against each case number...

I have a set of data and i have done vlookup what i need is to calculate cost on two different base levels https://imgur.com/IvskNuw heres a link to the image. now i when i enter data that is in the lvl column in the second table and the third table i have set for vlookup to get the data...

Right. I started Power BI this morning for the very first time. I've had no training (the power BI guy here is always too busy). I've very familiar with Excel and Access, have worked as a SQL Server developer so I know what I want to do, just not how. So, baby steps for my first table. I've...

Hi all. Could anyone please help with a division query. The Lots have been split into separate lines from the codes in Column C. The total cost of the Lots combined are in Column E Is there a way to divide the total cost by the number of items in the Lot As there are 7 items within Lot 668...

I have several vertical ranges of zip codes with each range equaling a specific delivery cost. If I type the a zip code in one cell, I want the cell next to it to show the price of delivery. I have been successful with different formulas, but they have only worked with one range at a time. I...

Hello, I would like to be able to drag the cell from C3 all the way down to C7 and still retain the formula on income / amount equals percentage. In other words, $100 / $1,000 is 10%. When I drag cell C3 down to C4, it changes the formula to $125 / BLANK = #DIV/0!. How can I set the formula...

Hi All, My brain has gone completely blank. I've got a table of data which id like to extract certain results according to date. So for example multiple people used the service within January, from this id like to work out the number of adults, if they were registered, total cost, what service...

I have wore google out past few days trying to figure this out. I am currently using vlookup to pull cost from another workbook. =VLOOKUP(C12,'

Hi I've been struggling to write a formula for my cash flow forecast for a week:( I have: 1. list of potential staff 2. their potential employment start date, highly subject to change 3. their cost of full time employment over a 36 month period...based on them all starting on the same date...

I want to add calculated subtotals into a pivot table Like in a finicial report you want to se Margins after different categories I have the scenario in the tabels below. My datatable is added to the datamodel with connection only. A table with balance per account, I have created an "Income...

I've got a spreadsheet with nearly a million rows, I've included a snippet below. Each SKU should have the same cost regardless of warehouse. Also, each SKU should have the same cost multiplier regardless of warehouse. I need to find SKU's which do not abide by this. So, SKU 1343qq1 should be...