LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JEV JEV is offline
external usenet poster
 
Posts: 9
Default SUM OF NUMBERS APPEAR INCORRECT?

EXCEL 2003

30,625.010000000000000000000000000000
(30,570.020000000000000000000000000000)

54.989999999998

Why does the sum of these 2 numbers yield the answer shown? The answer is
being compared to the following separate sum below and is yeilding a
different answer as well. The 2 numbers being added or subtracted are not
calculated- they're entered manually.

=15340-15285.01
54.990000000000

If the answer to the second equation is formatted out to more than 12 places
you get something less than the 54.99 I would have expected in both instances.

Appreciate your insight.
 
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
incorrect calculation Markies Excel Worksheet Functions 2 May 28th 08 08:27 PM
Incorrect Am and Pm MrBlackForest Excel Discussion (Misc queries) 2 January 26th 06 03:11 AM
Incorrect Sum ashlandpmac Excel Discussion (Misc queries) 1 April 15th 05 01:25 AM
Incorrect Sum AshlandPmac Excel Discussion (Misc queries) 1 April 14th 05 10:41 PM
incorrect totals using rounded numbers Alexis Excel Discussion (Misc queries) 1 March 23rd 05 11:19 PM


All times are GMT +1. The time now is 06:58 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"