# The Excel IMLOG2 Function

Related Function:
IMLOG10 Function

## Function Description

The Excel Imlog2 function calculates the base 2 logarithm of a supplied complex number.

The syntax of the function is:

IMLOG2( inumber )

where the inumber argument is the complex number that you want the base 2 logarithm of.

## Excel Imlog2 Function Examples

In the example spreadsheets below, the Excel Imlog2 function is used find the base 2 logarithm of five different complex numbers.

Formulas:
A
1=IMLOG2( "5+2i" )
2=IMLOG2( "2-i" )
3=IMLOG2( 6 )
4=IMLOG2( "3i" )
5=IMLOG2( "4+i" )
Results:
A
12.42899049756379+0.548954663286635i
21.16096404744368-0.668902106225488i
32.58496250072116
41.58496250072116+2.2661800709136i
52.04373142062517+0.353429502416735i

Note that, in the above example spreadsheet, the integer 6, used in cell B3, is equal to the complex number 6+0i.

Further details of the Excel Imlog2 function are provided on the Microsoft Office website.

## Imlog2 Function Errors

If you get an error from the Excel Imlog2 Function, this is likely to be one of the following:

Common Errors
 #NUM! - Occurs if the supplied inumber argument is not recognised as a complex number. #VALUE! - Occurs if the supplied inumber argument is a logical value.