PrecisionCalc
xl
Precision
Get Your Numbers Right
xlpE
Returns the mathematical constant e, the base of natural logarithms, with up to 32,767 significant digits of precision. e's decimal places continue infinitely and never repeat. The letter e was first used to represent the constant in 1727.
Syntax
xlpE(digits)
digits | Optional. The number of digits of E to return. Default is 100, or the maximum allowed by the xlPrecision edition, whichever is less. Maximum is 32,767. |
Remarks
xlPrecision results are returned as text that look like numbers, not as values that Excel recognizes as numbers. This is because Excel would truncate the results to 15 significant digits if it recognized them as numbers.
You can use the results of xlPrecision functions as the operands in other xlPrecision formulas without losing any precision, but using them as operands in Excel's arithmetic functions will truncate them to 15 significant digits.
Examples
Formula | Description | Result |
=xlpE(25) | The first 25 digits of e | 2.718281828459045235360287 |