L
Les
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 are:
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
(-14.05) for an equation containing subtraction of two negative numbers.
The Excel values are:
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