View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Les[_3_] Les[_3_] is offline
external usenet poster
 
Posts: 1
Default Why Subtracting Two Negative Numbers Results in Positive Number

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!