+ Reply to Thread
Results 1 to 4 of 4

Is there a way to get a few more than 15 decimals accuracy?

  1. #1
    Registered User
    Join Date
    09-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Is there a way to get a few more than 15 decimals accuracy?

    When I try to check a solution of 15 decimals, often Excel will miss compute the last decimal.

    I have checked a computations that excel showed as wrong, and found out Excel was wrong at so many decimals.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Is there a way to get a few more than 15 decimals accuracy?

    It's not just Excel. Double precision (15 digits) has been the standard for computer computations for years. Occasionally I have seen add-ins that use numbers as text strings to get higher precision, but they don't seem to be universally accepted. I've also heard of some programming languages that offer quad-precision (30 digits), but, again, it is not very common. I think it is because it is a very rare problem that really needs better than parts per quadrillion precision. If your problem really needs better than parts per quadrillion precision, I would suggest that, in the long term, you will be better served by learning a programming language that offers quad-precision.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Is there a way to get a few more than 15 decimals accuracy?

    Here's a lexographic program for very large integers.
    http://www.ozgrid.com/forum/showthread.php?t=78323
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  4. #4
    Registered User
    Join Date
    05-29-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Is there a way to get a few more than 15 decimals accuracy?

    curious what type of work needs that level of precision.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Number Accuracy
    By StevenAlberta in forum Excel General
    Replies: 3
    Last Post: 07-23-2012, 08:27 PM
  2. [SOLVED] Forecasting Accuracy
    By Gregc. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-02-2006, 09:10 PM
  3. Checking accuracy
    By schlempyasst in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2005, 03:18 PM
  4. CHecking accuracy
    By schlempyasst in forum Excel General
    Replies: 0
    Last Post: 10-13-2005, 03:15 PM
  5. Accuracy Studies
    By Ginny in forum Excel General
    Replies: 2
    Last Post: 04-01-2005, 08:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1