PrecisionCalc
xl
Precision
Get Your Numbers Right

 

xlpLOG

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

 

Syntax

xlpLOG(num,num_base,exponential_notation,maximum_significant_digits)

num Required. The number for which to find the logarithm. Must be a positive number.
num_base Required. The base of the number. Must be a positive number. 10 by default.
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
=xlpLOG(123) Logarithm of 123, to base 10.
=xlpLOG(123,16) Logarithm of 123, to base 16.
=xlpLOG(123,,TRUE) Logarithm of 123, to base 10, in exponential notation.
=xlpLOG(123,,,500) Logarithm of 123, to base 10, with 500 significant digits.

See Also

xlpLN
xlpEXP