View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Les Les is offline
external usenet poster
 
Posts: 240
Default 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