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 toLOG
for all non-complex values that are greater than zero.IMLOG
is equivalent toIMLN
given base ofe
, orEXP(1)
.IMLOG
is equivalent toIMLOG10
given base of10
.IMLOG
is equivalent toIMLOG2
given base of2
.
Examples
A | B |
---|---|
1 | Formula |
2 | =IMLOG("1+i", 3.5) |
3 | =IMLOG(COMPLEX(25, 34), 2.3) |
4 | =IMLOG(100, 10) |
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.