# calculation

1. ### Force Excel not to make calculation

Hi, I have a large Excel with a lot of data that requires a lot of calculation. The issue is that I can't even open it without freezing and have an message Excel not responding. Is there a way for me to open Excel without really open it to switch from auto calculation to manual calculation ?
2. ### Add hour in time with condition

Excel 2019 In cell A1 we have timestamp 23/06/2018 12:02:18 No in cell B2 we want to add four hours in but if timestamp is 23/06/2018 14:00:00 and office open and close time is 11:00 am to 5:00 pm then it will add four hours, according to office working hours 24/06/2018 13:00:00 and if...
3. ### Find Best combination of sum value or Nearest to sum value

Hi, I need an solution in VBA to find Best combination of sum value or Nearest to sum value from the list of data. For ex: in A column A1 = 10 A2 = 20 A3 = 35 A4 = 50 A5 = 60 Given sum value B1 = 100 B2 = 85 Expected output from macro A1 = 10 B2 A2 = 20 B2 A3 = 35 B1 A4 = 50 B2 A5 =...
4. ### Question regarding "Sheets("Sheet1").Range("A1:A10").Calculate" vs "Application.Calculation = xlManual/xlAutomatic"

Good day to You all! I've "inherited" an Excel file that works rather slowly. It consists of multiple sheets with 30+ columns and ±6000 rows containing VLOOKUPS, XLOOKUPS, etc. in lengthy tables. The file needs to be used by unexperienced people. Their work consists of adding/deleting rows and...
5. ### How to calculate months in fiscal year

Hello fellow colleagues, I have a task to calculate the number of months in a financial year (Australia) for grant payments that start in one year and end in the next, or in a few years. E.g. a \$49,790.40 grant, which payments begins on the 16/10/2018 and ends on the 30/06/2019. The time span...
6. ### Iferror miscalculation

Interesting one for you all - Excel 365. If I use a simple formula to subtract 1-1 I get, as you would expect a 0 (Row 2) However, if I nest this inside an iferror formula I get a very strange answer (yellow cell). (Row 3) Anyone any thoughts on why this is happening?
7. ### VBA Expiry date with entire row Color highlight & new column with status

I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example A B C D SL NO PRODUCT MANUFACTURING DATE EXPIRY DATE 1 ABC 01-01-2021 01-01-2022 2 XYZ 29-03-2021 29-03-2022 3 CDA 04-05-2019 04-05-2020 4 TWC 23-03-2021 23-03-2021 I want my output as...
8. ### Calculate Tenure with Several Variables

I am trying to create a formula that answers the following question: What is the Tenure at the end of 2018 (12/31/2018) for a person that has a HIRED DATE before 12/31/2018 and has a TERMINATION DATE that is either within or after 2018. I really appreciate the help, I just cant get the...
9. ### Calculate Tenure with a Twist

So I have two sheets. One sheet has my employee list with historic Start and End Dates. My other sheet is the summary of that list by Month. For example, lets say I have 10 Employees on my Employee sheet that all have Start and End dates, on my second sheet I have to summarize that info by...
10. ### SDLT Calculation Excel Formula

Can someone help me to create an excel formula for the updated version of UK SDLT ?
11. ### SUM function entered as an array formula will not sum the array, but will when entered as a standard formula

Hi All, Very familiar with the ins/outs of using complex array formulas, but found the strangest issue with SUM not summing the numerical contents of the reduced array, e.g., =SUM({0,0,1,0,0})...and this produces a zero. However, it works as intended by entering it as a standard formula (just...
12. ### Variable value changing for no reason

I'm passing values from one Excel sheet to others, it turns out that the variable P666_2 has the value "xxx.xxxx" but when the value is passed to the other sheet the value is in the format "xxxxxxx,0000", can someone help me solve it this problem? Sheets("Calculation_Sheet").Visible = True...
13. ### Calculating average of weighted grades in ever-expanding table

I am creating a gradebook which has users add new evaluations through a VBA userform. Each new evaluation is added to the next empty column in the worksheet. Two of the data entered are the Category and the Points. In the sheet Settings!K2:L17, the Category code (column K) is associated with...

Hi Excel Masters, I would like to ask help on how to calculate this in excel, there two scenarios: Problem #1: 864434038623597 + 2833349361FC = (answer)getting error here then (answer) * 11 = (answer #2) then (answer #2) must be calculated using NCK to get the 11 digit answer. please help...
15. ### Formula to calculate employee cost when total salary is given and industry average per employee is given

Hi, Please help with formula or a method to calculate per employee job level salary cost for different departments when we only have is total salary cost employee for entire dept. We are also given average salary for each level of employee. Below are the details Average salary per Job level...
16. ### Calculation Question (3 Different Sequences)

Calculation Question (3 Different Sequences) Please provide the formula starting with an = sign that I can drag down. Seeking the answers in the green highlighted areas. The green area has the correct answer. I am simply deleting the first 2 digits of each sequence, but I do not know the...
17. ### Stupid calculation I can't figure out...

Hello everyone, Today I have come across a very stupid calculation which I just cannot figure out how to solve. I already feel dumb enough as it is so yeah here goes: The table on the right is where I fill in all the "resources" I have (this is for a game, I'm sorry if this isn't meant for any...
18. ### Optional Rows in calculation

Hi there. This seems really simple, but honestly not sure how to accomplish. I'm making a simple trip planner in excel, and I have a total row to total expenses. I'd like to be able make certain trip expenses optional so we can quickly see how skipping/attending certain things affects our total...
19. ### Query table not load on sheet

Hi, I am starting to use Power Query. After query table is done, I load it to a specific sheet to get the results, then I can use again this table for further calculations. My question is: do I mandatory need to load the query table in a sheet to get the data for further calculation in excel...
20. ### Excel performance analysis - Software

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back