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.

Search This Blog

Description of Preview of Quality Rollup for .NET Framework 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, and 4.7.2 for Windows 7 SP1 and Server 2008 R2 SP1 and for .NET Framework 4.6 for Server 2008 SP2 (KB 4457016) - Microsoft Support [MS]

Description of Preview of Quality Rollup for .NET Framework 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, a...