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

PartDescriptionNotes
valueThe 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.
baseThe 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

AB
1Formula
2=IMLOG("1+i", 3.5)
3=IMLOG(COMPLEX(25, 34), 2.3)
4=IMLOG(100, 10)

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.