PrecisionCalc
xl
Precision
Get Your Numbers Right

 

xlpLN

Returns the natural logarithm of a number, with up to 32,767 significant digits of precision. Same as Excel's built-in LN function, but with high precision.

The natural logarithm is the logarithm to the base of the constant e. The constant e is approximately 2.71828. xlpLN uses the constant e with up to 32,767 significant digits of precision.

 

Syntax

xlpLN(num,exponential_notation,maximum_significant_digits)

num Required. The number for which to find the logarithm. Must be a positive number.
exponential_notation Optional. Determines whether result is formatted in exponential notation. Set to TRUE to format in exponential notation. FALSE by default.
maximum_significant_digits Optional. Determines the maximum number of significant digits to be returned. Default is 100, or the user's custom maximum set in the About box, or the maximum number allowed by the edition of xlPrecision, whichever is less.

Remarks

Examples

Formula Description
=xlpLN(123) Natural Logarithm of 123.
=xlpLN(123,,TRUE) Natural Logarithm of 123, in exponential notation.
=xlpLN(123,,,500) Natural Logarithm of 123, with 500 significant digits.

See Also

xlpLOG
xlpEXP
xlpE