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

Was this helpful?
How can we improve it?