Documentation/Calc Functions/IMLOG10

Function name:
IMLOG10

Category:
Add-in

Summary:
Calculates the logarithm to the base 10 or common logarithm of a complex number.

Syntax:
IMLOG10(ComplexNumber)

Returns:
Returns a text string giving the complex number that is the common logarithm of the complex number passed as argument.

Arguments:
ComplexNumber is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, which is the complex number for which the common logarithm is to be calculated. a and b are real numbers.


 * If ComplexNumber does not have an imaginary part (b equal to 0), the real part can be passed to IMLOG10 as a number rather than a string.
 * If both real and imaginary parts of ComplexNumber are 0, IMLOG10 reports an invalid argument error (Err:502).
 * If ComplexNumber is not a valid complex number, IMLOG10 reports an invalid argument error (Err:502).

Details specific to IMLOG10 function
For a complex number of the form a+bi, the common logarithm is given by the following equation:
 * IMLOG10(“a+bi”) = 0.434294481903251828 * IMLN(“a+bi”)

The value 0.434294481903251828 is the common logarithm of the mathematical constant e, which is known as Euler's number and has a value of approximately 2.71828.

Related LibreOffice functions:
IMEXP

IMLN

IMLOG2

IMPOWER

IMSQRT

ODF standard:
Section 6.8.15, part 2

Equivalent Excel functions:
IMLOG10