November 30, 2023

How to use IMLOG2 Function in Excel

The IMLOG2 function returns the base-2 logarithm of a complex number in x + yi or x + yj text format

Syntax:= IMLOG2(inumber)

The IMLOG2 function syntax has the following arguments:

  • Inumber: Required. A complex number for which you want the base-2 logarithm

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

IMLOG2 Function - How to use IMLOG2 Function in Excel

Syntax:  =IMLOG2(A2)


IMLOG2 Function in Excel 1 - How to use IMLOG2 Function in Excel

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

Syntax: =IMLOG2(A3)
Result: 1.16096404744368-1.59727796468811i

Syntax: =IMLOG2(A4)
Result: 2.32192809488736+1.33780421245098i

Syntax: =IMLOG2(A5)
Result: 1.42899049756379-0.548954663286635i

Syntax: =IMLOG2(A6)
Result: 2

Syntax: =IMLOG2(A7)
Result: 4.58496250072116+2.2661800709136i

Syntax: =IMLOG2(A8)
Result: 3.24592654816484+0.46418792923131i

Syntax: =IMLOG2(A9)
Result: 2.67877600230904+1.29273465968293i

Syntax: =IMLOG2(A10)
Result: 3.64731037444581-1.54577503186151i

Syntax: =IMLOG2(A11)
Result: 3.70043971814109-1.69661688033575i

Syntax: =IMLOG2(A12)
Result: 4.48289214233104-1.59727796468811j

Syntax: =IMLOG2(A13)
Result: 7.91348523474042+2.12834273498197i


  • Complex Numbers in Excel are simply stored as text.
  • When a text string in the format “a + bi” or “a + bj” is supplied to one of Excel’s built-in Complex Number Functions, this is interpreted as a complex number.
  • The complex number functions can accept a simple numeric value, as this is equivalent to a complex number whose imaginary coefficient is equal to 0.
  • Use COMPLEX to convert real and imaginary coefficients into a complex number.
  • If inumber is not recognized as a complex number, IMLOG2 returns the #NUM! error.
  • If inumber is a logical value, IMLOG2 returns the #VALUE! Error.
  • The base-2 logarithm of a complex number can be calculated from the natural logarithm as follows: IMLOG2 Function in Excel - How to use IMLOG2 Function in Excel
READ:  How to use BIN2HEX Function in Excel

Leave a Reply

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