xlPrecision 3.1

Get vastly more precise results from mathematical formulas in Microsoft Excel with xlPrecision, an Add-In for Excel.

Do arithmetic and other numeric analysis on very large numbers without rounding or truncating your numbers to 15 significant digits, as Excel does on its own. Don't be held back by Excel's limitation of only 15 significant digits!

Eliminate the stealthy binary conversion errors that plague spreadsheets. Binary conversion errors do not occur with xlPrecision in Excel.

Use much larger (and much smaller) numbers than Excel allows on its own. Excel only understands numbers from about 2.223E-308 to about 1.798E 308. With xlPrecision in Excel, use numbers as tiny as 1.000E-32765 and as huge as about 9.999E 32766.

xlPrecision offers many additional features that take you beyond Excel's capabilities in other ways.

v3.1 [Jan 6, 2010]
- Faster calculation speed:
- Division calculation speed is improved in xlPrecision 3.1. The improvement varies with the lengths of the divisor, dividend, and quotient, but for most scenarios it is about 10 - 15 TIMES faster.
Of course, all other xlPrecision functions that use division (which is most of them) benefit from this improvement, too, to varying degrees depending on how much they use division.
- Multiplication calculation speed is improved in xlPrecision 3.1. The longer the multiplication product, the greater the improvement. With a 400,000-digit product, it's about 18 times faster. With a 32,000-digit product, it's about 10 times faster. With a 1,000-digit product, it's about 40% faster. With a 100-digit product, it's about 10% faster.
Of course, all other xlPrecision functions that use multiplication (which is most of them) benefit from this improvement, too, to varying degrees depending on how much they use multiplication.
- Format Decimal Place:
- xlPrecision 3.1 adds the format_decimal_place parameter to several xlPrecision functions, allowing you to easily specify that you want digits to always appear exactly out to whatever decimal position you specify.
- Version 3.1 also adds the new xlpDEFAULTMAXSD function, which allows you to determine the default maximum significant digits currently in effect.
- Customize the default maximum significant digits:
On editions that allow more than 100 significant digits, xlPrecision prevents inadvertently causing long calculations by defaulting to 100 significant digits unless a custom maximum is specified in the function's maximum_significant_digits parameter. Now, version 3.1 allows you to customize that default from 100 to any number you wish.