IMLOG functionThe IMLOG function returns the logarithm of a complex number for a specified base.
Parts of an IMLOG formula
The IMLOG formula is formatted as =IMLOG(value, base).
The input value of the logarithm function.
The number can be written as plain numbers, e.g. 1, to be interpreted as a real number.
The number can be written as quoted text in order to specify both the real and complex coefficients.
The base to use when calculating the logarithm.
Must be a positive real number.
IMLOG(COMPLEX(25, 34), 2.3)
IMLOG is equivalent to LOG for all non-complex values that are greater than zero.
IMLOG is equivalent to IMLN given base of e, or EXP(1).
IMLOG is equivalent to IMLOG10 given base of 10.
IMLOG is equivalent to IMLOG2 given base of 2.
=IMLOG(COMPLEX(25, 34), 2.3)
IMLN: The IMLN function returns the logarithm of a complex number, base e (Euler’s number).
IMLOG10: The IMLOG10 function returns the logarithm of a complex number with base 10.
IMLOG2: The IMLOG2 function returns the logarithm of a complex number with base 2.
COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
IMAGINARY: Returns the imaginary coefficient of a complex number.
IMREAL: Returns the real coefficient of a complex number.
LOG: Returns the the logarithm of a number given a base.