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