calculation

  1. V

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

    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 =...
  3. B

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

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

    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?
  6. M

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

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

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

    SDLT Calculation Excel Formula

    Can someone help me to create an excel formula for the updated version of UK SDLT ?
  10. Give Me Arrays

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

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

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

    Please help on Calculation using excel

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

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

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

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

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

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

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

    Subtracting times, negative result

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top