EXCEL IMLN FUNCTION

The Imln function in Excel returns the log transformation of a complex value.

Syntax :

=IMLN( inumber )

Parameters :

  • The inumber parameter is the complex integer whose natural logarithm you seek.

Step By Step Guide of IMLN Function

Example :

The worksheets below provide four Imln function examples:
The complex number 2+0i is equivalent to the integer 2 in cell B1; the example in cell B4 utilises the Excel Complex Function to generate the complex number 1-i.

  • #NUM! – This error occurs if the given inumber parameter is not a complex number.
  • #VALUE! – Occurs if the inumber parameter given is a logical value.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now