IMLOG function

The 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).

Part	Description	Notes
value	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.
base	The base to use when calculating the logarithm.	Must be a positive real number.

Sample formulas 

IMLOG("1+i", 3.5)

IMLOG(COMPLEX(25, 34), 2.3)

IMLOG(100, 10)

Notes

• 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.

Examples

	A	B
1	Formula	Result
2	=IMLOG("1+i", 3.5)	0.276647377832556+0.626932774314643i
3	=IMLOG(COMPLEX(25, 34), 2.3)	4.49324546771284+1.12470086031758i
4	=IMLOG(100, 10)	2

Related function 

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 logarithm of a number given a base.