IMLN functionThe IMLN function returns the logarithm of a complex number, base e (Euler’s number).
Parts of a IMLN formula
The IMLN formula is formatted as =IIMLN(number).
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.
IMLN is equivalent to LN for all non-complex values that are greater than zero.
IMLN is equivalent to LOG given base of e, or EXP(1), for all non-complex values that are greater than zero.
The natural logarithm of a complex number is defined as follows:
ln(x+yi) = √(x2+y2) + i tan-1(y/x)
LN: Returns the the logarithm of a number, base e (Euler’s number).
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.
LOG10: Returns the the logarithm of a number, base 10.
LOG: Returns the the logarithm of a number given a base.
EXP: Returns Euler’s number, e (~2.718) raised to a power.