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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.