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