September 28, 2021

How to use IMLN Function in Excel

The IMLN function returns the natural logarithm of a complex number in x + yi or x + yj text format

Syntax:= IMLN(inumber)

The IMLN function syntax has the following arguments:

  • Inumber: Required. A complex number for which you want the natural logarithm

Example: Let’s look at some Excel IMLN function examples and explore how to use the IMLN function as a worksheet function in Microsoft Excel:

IMLN Function - How to use IMLN Function in Excel

Syntax:  =IMLN(A2)


IMLN Function 1 - How to use IMLN Function in Excel

Based on the Excel spreadsheet above, the following IMLN examples would return:

Syntax: =IMLN(A3)
Result: 1.03972077083992+0.785398163397448i

Syntax: =IMLN(A4)
Result: 1.6094379124341+0.927295218001612i

Syntax: =IMLN(A5)
Result: 0.346573590279973+0.785398163397448i

Syntax: =IMLN(A62)
Result: 1.38629436111989

Syntax: =IMLN(A7)
Result: 3.17805383034795+1.5707963267949i

Syntax: =IMLN(A8)
Result: 2.24990483516513+0.321750554396642i

Syntax: =IMLN(A9)
Result: 1.85678603335215+0.896055384571344i

Syntax: =IMLN(A10)
Result: 2.52812290267415-1.07144960511477i

Syntax: =IMLN(A11)
Result: 2.56494935746154-1.17600520709514i

Syntax: =IMLN(A12)
Result: 3.1073040492111-1.10714871779409j

Syntax: =IMLN(A13)
Result: 5.48520997886308+1.47525476601799i


  • Use COMPLEX to convert real and imaginary coefficients into a complex number.
  • The natural logarithm of a complex number is: IMLN Function in Excel - How to use IMLN Function in Excel

READ:  How to use HEX2DEC Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *