LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 2003 Calculation Error

Hi,
I found a Calculation error in Excel 2003.

A1 = 114470.41
A2 = 114400.00
A3 = 70.41

A5 = A1 -A2
A6 = A3 - A5

Note: Excel is suppose to give as result 0.00, however it's giving
(-3.49587025993969E-12)'

Can I get an answer on this? if there is a way that can be resolve or will
be resolve in the future.
--
Knowledge is just a Tool! There is more to live for!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
 
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
VBA Error in Excel 2003 Mike Flory Excel Discussion (Misc queries) 14 April 4th 23 10:34 AM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
Calculation Excel 2000 - Excel 2003 Hege M Excel Discussion (Misc queries) 0 May 11th 06 12:18 PM
default manual calculation instead of auto in options excel 2003 Lost in Excel Excel Discussion (Misc queries) 1 October 9th 05 06:55 PM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM


All times are GMT +1. The time now is 02:26 PM.

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

About Us

"It's about Microsoft Excel"