calculation

Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc? I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every...

Hi, I'm sure this is quite simple but I'm not getting it. I want to subtract to time values where the result (in this case) will be negative: Time A is entered manually as e.g. 13:30 Time B is a result of a calculation and shows as 16:00 The result should be -2:30?? I've tried different ways but...

I'm building a spreadsheet for running the asset list, it calculates monthly depreciation and builds the accounts journal. Its under 1Mb of data. There are various formulas going on, simple SUM to SUMIFS but very few VLOOKUP. I entered a SUM to add up a column, the result was £0. ISNUMBER...

Hope someone can help I am trying to change the calculation returned in 1 cell depending on the entry of "X" in another If an "X" is entered in I2 run the calculation in Worksheet1 - =IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5 If an "X" is entered in J2 run the calculation in Worksheet2 -...

I want to enter a formula in sheet name "calculation" B4 that if the Date in Sheet named "Raw Data" Header named "Date" is withing the week 44 date that in the Sheet named "Calculation" D2 sum the data in the sheet named "Raw Data" heater named "Count of Assets in BU"

Hi Guys, i just completed my registration as I guess you are playing the Championsleague of Excel, so I think it is the best place for a special question. Think about a workbook having 2 sheets, the first sheet has multiple lines meaning multiple records with the same structure. The columns...

Hows it going everyone, i'm VERY new to creating Excel formulas (less than 24 hours as of now). I've started to create a spreadsheet in Excel for my coworkers to eventually use in order to provide our clients costs for various services quickly & to ensure there aren't any errors in the...

Hi there, I have a calculation taking place on a work sheet - a calculation to work out a percentage. =IFERROR(SUM(D6/D5),0) In this example I'm using Loan (£100,000) / Property Value (£200,000) = 0.5 (formatted to %) = 50% All I want to do it have my user form pull through the value of...

This formula is supposed to test if one cell value is less than another, if so, show nothing, if not, then do a percentage calculation and show that, what am i missing? =IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100"))) Happy to share the spreadsheet if it helps, it's nothing personal. Here's how it...

Hello, I've got a problem with a couple formulas I've entered on a spreadsheet. The first formula is performing a calculation based on data from another tab. I want it to round the results to the nearest whole number. I can click "Decrease Decimal" and it shows 1.9 as 2 for example. The...

Hi There - I need a working day calculation - but with a twist. Here is my example: A1 = 5/17/19 B1 = 8/1/19 C1 = _________ Part A: I need day #1 to be the first working day after 5/18/19. And then I need the last working day to be the day of B1. And I need to exclude a list of...

HI All, hoping for some quick help. Most probably a quick easy fix, but cant think what other way to work it. I am trying to use the below formula, but it isn't correct and I am not sure how to fix it. =IF(Original!P2=400 or 250,0),round(Data!Q2/Data!P2*100,2) Basically if the data in the...

Recently and inexplicably any new workbooks that I open default to manual calculation. I read a few message boards and they said that the solution is to put a workbook in the XLSTART folder that s set to automatic calculation. This works, however any time I open an existing workbook it opens...

hello, i would like to know if there’s an equation to help me automatically calculate/multiply any extra 1 percent after 100% with 1.5 as factor for the extra 1 percent

I'm trying to do a calculation where time can be added but only adds within working hours & days. I found this calculation...

I am working on a spread sheet that in one specific cell(we'll say Sheet1 A1) I need it to display another cell on another page(Sheet2 B36). Thats easy enough, but then at each calculation I need the cell above the original cell that was being displayed to be displayed (so now its displaying...

Hi I have a standard calculation that I work out for interest that I am happy works correctly =SUM(G5*F5*D5/365) Yet when i use the FV function I am getting a different total for this one calculation based on £1000 @ 8% =FV(F5/365,D5,0,-G5)-G5 I should be getting 22p at 8% which is what...

Okay, so question i have is this, i have a budget sheet that has the monthly bills in their own cell and my net on top and the leftover on the bottom. so basically the leftover formula is the sum of the positive currency minus the bills. so what i am trying to do is once the payment is taken...

Is there a way to calculate the number of work days between two days? If so, how? Very new to Power Query...….

Hi I have a formula in a spreadsheet which i need help to understand This is the 1st part of a calculation. I understand the rest of the calculation except this natural logarithm =((LN(D5/10)*-0.5179)+2.66)*D6 This is then the following =((LN(temperature/10)*-0.5179)+2.66)*flow rate Values...