costs

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

hi all can someone explain the following formula in simple terms please - what is this achieving ? =SUM(F4*(1+E4)^D4) F4 = £547,000 (Total set up costs) E4 = 3% (Inflation) D4 = 5 years (Life) so the above formula result is £634,123

Hi, I have some table data where I would like to generate an aggregate reciprocal position. This relates to modelling allocation of costs within an organisation. E.g. 5 departments a, b, c, d, e receive costs of -1, -2, -3, -4, -5 respectively. I would like to generate in the cleanest and...

Hi, Would really appreciate input on how I can get my formula working. Excel screen shot: https://imgur.com/a/9JC8UhS How I want the formula to function: If "Group" in column B= 1000 or 2000, in this case B8 and B9, then, I want the formula to sum all costs in column C, except for the...

I'm trying to extract specific fields from multiple sheets in to one sheet. Each sheet has multiple rows with row heading as ID, name, total costs, total revenue. I need to find the rows that have these headings. Then the value for each one is listed in different columns - like ID value is...

Hello, I have a basic Vlookup formula that I am using to add certain job costs. The formula is as follows: =IFERROR(VLOOKUP(B235,'1530 - WIP MATERIALS '!A:H,5,FALSE),0) The formula is looking for a specific job number and returning the associated costs, however it is only returning the first...

Hi How do I create to IF arguments for the same cell relating to text: So if cell A1 = "Non Portfolio" or "Portfolio status not yet known" then I want it to output "ALL COSTS", if false, then just blank. So normally for 1 argument it would be =IF($C$33="Non Portfolio"," ","ALL COSTS") Thank...

All, I have a situation where I need to calculate within a pivot table. I need to calculate a delta between two columns that are at the second level. In other words, the elements that need to be calculated are pivoted and not their own individual field. Is there a way to do this. If it...

I have become reasonably adept at Excel over the years - mainly thanks from Mr Excel. However. I am a novice with Pivot tables. I am trying to extract & analyse product costs from 50k plus (and growing) rows. I also need to make it as simple to operate, using Macros & VBA if necessary as...

Hey guys. I was recommended you guys by my friend, who said you guys were geniuses - Hopefully you can help me with my problem! :) Question: I have a cash flow question within the subject of financing. In here I have a time series of Costs in my cash flow with -6m in each period (Could be...

Hello! I had posted this question on Stack Overflow, but was told that it isn't the right place for such a question. I have two sheets in Excel, one with formulae calculating business costs, and another where I'm trying to calculate revenue projections based on those costs. Images: Costs...

First off I am new as of today to this board. Thank you in advance for your help. I know a little about excel but when it come to completing advanced formulas I need help. I am creating a set of three sheets for my company to help track our rental equipment and costs yearly. I currently have...

Hey everyone, Please help me pass the CPCU (a massive set of insurance tests). I'd like to combine rows of text in excel, to upload into a flashcard program. The format I start with looks something like this (each line would be its on its own row in its own cell): <tbody> <tbody> 293...

Hello everybody The following situation I'm struggling for some time right now, I feel like I'm close to solving it, though I do not succeed. What I want: Let's say that in sheet 1 I have one table containing data, with a header, names and amounts. In sheet 2 I want to lookup the sum of...

I'd like to calculate and plot on a chart weekly costs for staying at various hotels, based on start & end dates being keyed. For instance I would like to key: Hotel A - 2/3/17 - 7/6/17 £345 pw Hotel B - 8/6/17 - 10/7/17 £506 pw Rather than just calculate the total costs I would like to show a...

Hi everyone, I am in need of some help with the following and appreciate if any of you could help on this. Very much appreciated. Column G, H, I and J are a drop down list which I could simply select the Staff names and the row will adjust the Total Staff Costs accordingly. Column K which is...

Hello, I have table like the one below. I'd like a macro to select a range in that table which I specify. For example: if I type 'Budget' in cell B2 and 'Quarter 4' in cell B3, I'd like the macro to select range F11:F14; or if I type 'Actual' in B2 and 'Quarter 2' in B3, I'd like the...

Not sure if my title is exactly what I'm looking for but what I'm trying to do is lookup a value based on two criteria. The best way to show you what I'm looking to do is to just show a sample of what I'm trying to do. Whatever is in cell A2 (District 3), I want the formulas in column B to...

Hi, I am trying to find the way to compare products costs between 3 vendors against mine and generate a sell rate with the best profit possible. So, for example the best competitor cost is $1 and mine is $ 0.50, I want to generate a rate to be close and below to $1. Do you know any macro or...

Hi, I am a beginner in VBA. Basically I need a code that generates a new workbook for each specific column value in multiple sheets. The key in each sheet is the column Group. In total there are 6 sheets in the original file with the following columns. Sheet General Data Location Project...