+ Reply to Thread
Results 1 to 4 of 4

Difference Formula or Hiding the - sign with a subtract formula.

  1. #1
    Registered User
    Join Date
    12-04-2015
    Location
    Lancashire
    MS-Off Ver
    2010
    Posts
    15

    Question Difference Formula or Hiding the - sign with a subtract formula.

    Hi Guys,
    Just a quick one...
    I have a set of numerical data in 2 columns next to each other. I want to see the difference between the two. I usually use "=A1-B1" and then copy it down, if B1 has a greater value than A1 and shows the minus sign I simply swap the formula around to "=B1-A1". Here is the issue though, this has worked fine for me when I have been working with no more than 10 rows of data.... but now I have 100s rows of data and I want to pop the formula in the top cell and copy it down in one swift go to save time.

    Any formula suggestions will be a great help.
    Or a VBA if that works better.

    Thanks
    Last edited by JonWilf; 09-19-2016 at 01:34 PM. Reason: SOLVED

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Difference Formula or Hiding the - sign with a subtract formula.

    Just take the absolute value. For example, =ABS(A1-B1)

  3. #3
    Registered User
    Join Date
    12-04-2015
    Location
    Lancashire
    MS-Off Ver
    2010
    Posts
    15

    Re: Difference Formula or Hiding the - sign with a subtract formula.

    Brilliant, I knew it would be something so simple and right infront off me.... thank you for the help

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Difference Formula or Hiding the - sign with a subtract formula.

    Glad to help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Write VBA code checks the sign of the difference of 2 given number
    By sontranhus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2014, 11:12 AM
  2. [SOLVED] How to avoid formula circular references and hiding and locking the formula
    By Venkata Krishna in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 06-21-2013, 08:17 AM
  3. [SOLVED] Formula to use to subtract 2 cells in a row and put the same formula for over 1000 rows
    By milk1one in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2012, 12:08 AM
  4. Replies: 12
    Last Post: 04-22-2010, 03:33 AM
  5. hiding the % sign
    By bagullo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-29-2009, 11:40 PM
  6. [SOLVED] Deg.Min difference doesn't show minus sign
    By jilaba in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-04-2009, 11:03 AM
  7. Formula question-formula to subtract multiple cells
    By arrchapman in forum Excel General
    Replies: 3
    Last Post: 04-17-2008, 04:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1