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
-
IMLOGis equivalent toLOGfor all non-complex values that are greater than zero. -
IMLOGis equivalent toIMLNgiven base ofe, orEXP(1). -
IMLOGis equivalent toIMLOG10given base of10. -
IMLOGis equivalent toIMLOG2given base of2.
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.
