LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 : Convert Positive Numbers to Negative Numbers ? Mr. Low Excel Discussion (Misc queries) 2 November 6th 06 03:30 PM
change 2000 cells (negative numbers) into positive numbers lisbern Excel Worksheet Functions 2 August 16th 06 05:54 PM
convert negative numbers to positive numbers and vice versa bill gras Excel Worksheet Functions 4 December 7th 05 01:39 AM
How to add all positive and negative numbers? Knold10 Excel Worksheet Functions 1 November 19th 05 03:02 AM
Subtracting Negative Numbers Carole O Excel Worksheet Functions 2 January 4th 05 06:31 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"