Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Calc error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michel Finschi - 07 Jan 2006 12:52 GMT
Got a tricky error in my Excel (2004 for Mac, Version 11.2 (050714)

The difference between the two figures:

a1 6833.40
a2 6828.66

Important note: both figures were manually entered exactly as above, no
further (hidden) digits.

Is correctly calculated by Excel as 4.74 in cell a3. So far, so good.

However, when increasing the number of digits for a3 to the max of 30, then
Excel returns the result:

4.739999999999780000000000000000,

Why is this?

Thanks, Michel
Niek Otten - 07 Jan 2006 13:08 GMT
Hi Michel,

See

http://support.microsoft.com/kb/78113

Signature

Kind regards,

Niek Otten

> Got a tricky error in my Excel (2004 for Mac, Version 11.2 (050714)
>
[quoted text clipped - 17 lines]
>
> Thanks, Michel
Michel Finschi - 07 Jan 2006 16:18 GMT
Excellent, thanks Niek.

in Beitrag Ofnl$t4EGHA.2040@TK2MSFTNGP14.phx.gbl schrieb Niek Otten unter
nicolaus@xs4all.nl am 7.1.2006 14:08 Uhr:

> Hi Michel,
>
> See
>
> http://support.microsoft.com/kb/78113
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.