Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Numbers Have Positive Result
I'm using Excel 2007 and am having trouble getting the correct result of
(-14.05) for an equation containing subtraction of two negative numbers. The Excel values a B9 = - 450.00 F9 = - 400.00 C11 = 7.12 Using the above values, the equation formula should work like this: = 2*(- 450.00 - - 400.00)/7.12 (note the subtracting of 2 negative numbers) = 2*(-50)/7.12 = - 100/7.12 = - 14.05 I've setup Excel as: 2*(B9-F9)/C11 but the result always comes out as a positive 14.05 instead of negative (- 14.05). I've formatted the cell for Numbers and selected the negative format using the hyphen. Any ideas? I'm just stumped. Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
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 |