Why Subtracting Two Negative Numbers Results in Positive Number
Try:
=SUM(C8,F8)
or just:
=C8+F8
The SUM is actually redundant here. You're just trying to *add* two
negative numbers, not taking one away from the other.
Regards
Trevor
"Les" <Les @discussions.microsoft.com wrote in message
...
Hi~
I'm using Excel 2007 and ran into a problem when creating a formula that
references two cells (C8 and F8) where users will enter a negative number
in
each cell. So for example, the user would enter the following numbers:
Cell C8 ------ -4424.872
Cell F8 ------- -4278.982
To subtract both numbers I created the formula: SUM(C8-F8). But the
problem is that instead of returning a negative number, the result is
shown
as a positive number. I'm not sure why this happening. Could someone
point
me in the right direction?
Thanks for the time and expertise!
|