sheets.wiki

IMLOG

2 min read

INFO

This page was originally generated from official documentation.

The IMLOG function returns the logarithm of a complex number for a specified base.

Syntax

IMLOG(value, base)
  • 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

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.