IMLN Function in Excel – Get the Natural Logarithm of a complex number

IMLN Function in Excel returns the Natural Logarithm of a supplied complex number.

The Natural Logarithm of a complex number z = x + iy is calculated by the equation,

Syntax of IMLN Function in Excel

IMLN( inumber )

Where inumber argument is a Complex Number.

Example of IMLN Function in Excel

Formula

IMLN Function in Excel 1

From Row number 2 to 5 IMLN Function takes up complex number as a reference
In row number 6 IMLN Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes
In row number 7 IMLN Function takes up real component as a value.

Result

IMLN Function in Excel 2

NOTE: #NUM! – Error occurs if,

supplied inumber argument is not recognized as a complex number.