About 329,000 results
Open links in new tab
  1. Adding a plus or minus sign into a formula that shows the …

    Aug 4, 2017 · Hello, I would like some help with a formula that tells me the difference between numbers in two cells but does so with a + or – sign depending on whether the number is lower …

  2. How do I calculate a difference (ignoring negatives) - MrExcel

    May 25, 2004 · How do I get a cell to display the difference between two other cells regardless of whether it is positive or negative. For example if cell A1 is 1 and cell A2 is 10, if I tell excel to …

  3. Returning Negative in DateDif | MrExcel Message Board

    Oct 10, 2005 · I need to calculate the difference between 2 dates, so was using

  4. Calculating percentage change with 0 values? - MrExcel

    Jun 14, 2010 · Ok. Here is the situation. I have two columns that I need to calculate the percentage change.. Column G is year 2010 Column F is year 2011 Column I is percentage …

  5. DateDiff to return positive and negative numbers - MrExcel

    Jun 4, 2014 · Hi, I searched for a solution, but couldn't find one that fit my specific needs, so I thought I'd turn to this great forum! I have a date in cell M2 and am wishing to calculate the …

  6. % difference between two values, which can either be positive or ...

    Oct 28, 2020 · Hello there - I have the need to determine the % between two different values (Actuals / Target). This normally works if both values are positive, or both are negative. I have …

  7. difference between two cells with negative/positive numbers

    Jun 10, 2014 · Hello all, I am trying to find the formula to give me the difference between two cells that contain negative numbers. Sorry if this is VERY 101. :// I...

  8. Calculate difference between 2 numbers, up to a certain number

    Aug 8, 2016 · Looking to calculate the difference between 2 numbers, up a certain max amount. Example: I want to find the difference between 200 (A1) and 100 (A2), which is 100 but allow …

  9. Finding the biggest difference in two ranges - MrExcel

    Jan 12, 2016 · Hello! This is my first post, and I'm looking to find the largest difference between two ranges of numbers and then find the corresponding cell to those two pieces of data. Let …

  10. Two different sum answers to identical numerical data - MrExcel

    Jul 22, 2015 · I have numerical data in two columns. A column (A1:A3) includes positive numbers and B column (B4:B26) includes negative numbers; and they all exactly net-off to zero. But …