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:

**Syntax**: =IMLOG2(A2)

**Result**:

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

**Note**:

- 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: