Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post
    I have a simple formula in a cell that shows the results of adding the totals of the two cells to the left. Basically cell C1 just says:

    =sum(A1+B1)

    So if A1 = 50.00 and B1 = .25 then C1 reads 50.25.

    Every now and then a negative number gets inserted in A1 but B1 remains positive. That is:

    A1 = -50.00 (negative 50.00) but B1 remains positive at .25.

    When this happens I need Cell C1 to read -50.25 (negative 50.25), but of course it shows -49.75 (negative 49.75) because negative 50.00 plus positive .25 equals -49.75.

    Can anyone suggest a way to make C1 to over ride the mathematical answer with the result I need when A1 is negative? Cell C1 must remain as a number as column C gets added up for a total value.

    Thanks,
    BH

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi BH - Try this ....
    =IF(A10>=0,A10+B10,(-A10+B10)*-1)


    Tim

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post
    Tim,

    Thanks for the suggestion. You got my ancient brain going in the right directions. I'm embarrassed to have to report the solution is as simple as:

    IF(J17<0,J17-K17,J17+K17)

    DOH

    Thanks again,
    BH

Posting Permissions

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