LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Improve Excel accuracy over 15 digits



Greg Lovern wrote:

On Aug 27, 7:02 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:

Now that every one else has waded in I will ask the question... Why would you
need more than 15 digits of accuracy? With that many digits I can get the
distance from here to the sun to less than a millimeter. Just curious.




Hi Jim,


Also BTW, I'm curious -- how does 15 significant digits of precision
get you the distance from here to the sun to less than a millimeter?
Isn't the average distance approximately 149,600,000,000,000
millimeters, which would let you get to the *nearest* millimeter in 15
significant digits of precision (or within one millimeter, assuming
truncation rather than rounding), but not to a fraction of a
millimeter? Not that it really matters, of course.


Simple, since 15 significant digits of precision can give you the
distance to the sun to the nearest millimeter the error will be LESS
than one millimeter.

 
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
Excel time format / accuracy Pete Fraser New Users to Excel 9 November 23rd 07 04:29 AM
how can i improve my skills in excel CmK Excel Worksheet Functions 4 December 17th 06 04:55 PM
improve help samples in excel 2003 Mac B Excel Discussion (Misc queries) 3 October 20th 06 06:22 PM
How do I improve Accuracy of trendlines? Tom21 Charts and Charting in Excel 3 August 1st 06 09:17 PM
How can I set the tab to improve navigation in Excel? stefanie Setting up and Configuration of Excel 1 November 9th 05 07:32 PM


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