LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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
How to change positive numbers to negative numbers without re-ente 9541moosegirl Excel Worksheet Functions 8 March 5th 08 05:35 PM
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


All times are GMT +1. The time now is 08:47 PM.

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

About Us

"It's about Microsoft Excel"