+ Reply to Thread
Results 1 to 5 of 5

How to sum a positive and negative number so the total is positive

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    Mullingar, Ireland
    MS-Off Ver
    2016
    Posts
    12

    How to sum a positive and negative number so the total is positive

    Hi im looking for a formula to sum two numbers together. Sometimes one column will have negative number but the total has to always be positive.

    Heres a photo:
    https://i.imgur.com/5FnD4UV.png

    I need the two net positions to equal a positive number, so its as if the minus is not in a column

  2. #2
    Registered User
    Join Date
    12-15-2017
    Location
    Fresno, CA
    MS-Off Ver
    2016
    Posts
    56

    Re: How to sum a positive and negative number so the total is positive

    A1=100 A2=-300
    =sum(ABS(A1),ABS(A2))
    result will be 400
    ABS() is the absolute value of an integer. This makes all negative numbers positive.

  3. #3
    Registered User
    Join Date
    12-15-2017
    Location
    Mullingar, Ireland
    MS-Off Ver
    2016
    Posts
    12

    Re: How to sum a positive and negative number so the total is positive

    Thank you thats awesome.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to sum a positive and negative number so the total is positive

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    12-15-2017
    Location
    Mullingar, Ireland
    MS-Off Ver
    2016
    Posts
    12

    Re: How to sum a positive and negative number so the total is positive

    Done, i could find it earlier!!

+ 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] Find pattern (positive, negative, positive)
    By tsakta13ole in forum Excel General
    Replies: 6
    Last Post: 06-01-2016, 05:10 AM
  2. [SOLVED] how total in excel all negative and all positive number
    By ECYOJ in forum Excel General
    Replies: 2
    Last Post: 04-03-2014, 11:30 PM
  3. Replies: 5
    Last Post: 11-17-2010, 09:03 PM
  4. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  5. Replies: 1
    Last Post: 08-14-2009, 11:17 AM
  6. adding positive and negative numbers all as positive
    By tomvh444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2009, 04:08 PM
  7. Replies: 2
    Last Post: 11-13-2008, 12:35 AM

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