# Thread: Recognizing a negative number

1. 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. Hi BH - Try this ....
=IF(A10>=0,A10+B10,(-A10+B10)*-1)

Tim

3. 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
•