Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
How to add all positive and negative numbers? | Excel Worksheet Functions | |||
Subtracting Negative Numbers | Excel Worksheet Functions |