Related Function:

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

Syntax

=IMLOG2(inumber)

Arguments

Argument Description
inumber A complex number for which you want the base-2 logarithm

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C D
1 Data Formula Result Notes
2 3+4i =IMLOG2(A2) 2.32192809488736+1.33780421245098i Base-2 logarithm of 3+4i
3   =IMLOG2(“3+4i”) 2.32192809488736+1.33780421245098i  
4   =IMLOG2(“2-i”) 1.16096404744368-0.668902106225488i  
5   =IMLOG2(COMPLEX(4,1)) 2.04373142062517+0.353429502416735i  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The base-2 logarithm of a complex number can be calculated from the natural logarithm as follows:  

    \[ log_2(x+yi) = (log_2 e)ln(x+yi)   \]

See Wikipedia for more information on complex numbers.