+ Reply to Thread
Results 1 to 8 of 8

How do I add a negative number to a sum of numbers?

  1. #1
    Registered User
    Join Date
    02-19-2007
    Posts
    11

    How do I add a negative number to a sum of numbers?

    $402.39

    $20,119.26

    ($800.00)
    ($1,100.00)


    The top number $402.39 should be 2% of the sum of the $20,119.26 and the two deductions of -$800 and -$1,100.

    My current formula looks like this 0.02*(SUM(L11:L23))

    It is adding the two negative numbers which results in a positive number. How do I get it to add the negative numbers and correctly get 2% of that?
    Last edited by COZWV; 04-20-2011 at 03:22 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Formula Help

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: How do I add a negative number to a sum of numbers?

    $402.39 is 2% of $20,119.26, so are you just wanting to ignore negative values in the sum? I am a bit confused.

    If so, then try :

    =SUMIF(L11:L23,">0")*0.02

  4. #4
    Registered User
    Join Date
    02-19-2007
    Posts
    11

    Re: How do I add a negative number to a sum of numbers?

    I am trying to get it to add the $20,119.26 and the ($800), ($1,100) which should equal $18,219.26 and then multiply to get 2% of the result. (Which should be $364.39)

    I know in my head that I need to subtract the $1,900 (-800 +-1,100) from the $20,119.26 but cannot figure out how to get excel to do it correctly?

  5. #5
    Registered User
    Join Date
    02-19-2007
    Posts
    11

    Re: How do I add a negative number to a sum of numbers?

    Seems I am looking to deep into it. The result is correct in Excel if I add all of the numbers and Multiply by 2%.

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: How do I add a negative number to a sum of numbers?

    That was your original formula, no?

  7. #7
    Registered User
    Join Date
    02-19-2007
    Posts
    11

    Re: How do I add a negative number to a sum of numbers?

    Quote Originally Posted by NBVC View Post
    That was your original formula, no?
    Yes it was. I hadn't added the two negative number cells to the formula AND I also caught myself subtracting the negative numbers on my calculator which is why it kept giving me an odd number. I was thinking I needed to subtract them but in reality by adding a negative number it was already doing that.

  8. #8
    Forum Contributor Charlie_Howell's Avatar
    Join Date
    09-27-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: How do I add a negative number to a sum of numbers?

    try this =A1-(SUM(A2:A3)*-1) to get $18,219.26
    =(A1+SUM(A2:A3))*0.02 to get $364.39

    are you adding ,subtracting or just trying to get to $364.39 ?

    Update Ive uploaded a sheet with some options for you.
    Attached Files Attached Files
    Last edited by Charlie_Howell; 04-20-2011 at 10:57 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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