+ Reply to Thread
Results 1 to 4 of 4

Comparing numbers

  1. 10-21-2014, 08:17 AM #1
    tpollock
    tpollock is offline
    Registered User
    Join Date
    08-24-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Comparing numbers

    I need a formula that will compare 2013 column to 2014 column and then return the neg number or the positive number. attached is example. thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-21-2014, 08:19 AM #2
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Comparing numbers

    You mean this ?
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  3. 10-21-2014, 08:19 AM #3
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Comparing numbers

    Perhaps

    =B2-A2

    ?
    Reply With QuoteRegister To Reply
  4. 10-21-2014, 08:53 AM #4
    tpollock
    tpollock is offline
    Registered User
    Join Date
    08-24-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Comparing numbers

    thanks everyone I had a total brain fart on that one. Thanks again.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing Two Numbers
    By Bob Lankin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 12:42 AM
  2. [SOLVED] Comparing numbers
    By JakeMann in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2013, 09:31 AM
  3. [SOLVED] Excel 2007 : Comparing a row of numbers to a range of numbers
    By egavasrg in forum Excel General
    Replies: 1
    Last Post: 08-19-2011, 09:55 PM
  4. Comparing row numbers
    By Axcelerate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2010, 10:39 AM
  5. Comparing numbers in lists/columns of numbers
    By Onesimus in forum Excel General
    Replies: 3
    Last Post: 12-15-2007, 02:19 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1