IMLOG2 Function in Excel

IMLOG2 Function in Excel returns the base 2 logarithm of a supplied complex number.

Syntax of IMLOG2 Function in Excel 

IMLOG2( inumber )

Where inumber argument is a Complex Number.

 

Example of IMLOG2 Function in Excel

Formula

IMLOG2 Function in Excel 1

  • From Row number 2 to 5 IMLOG2 Function takes up complex number as a reference
  • In row number 6 IMLOG2 Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes
  • In row number 7 IMLOG2 Function takes up real component as a value.

Result

IMLOG2 Function in Excel 2

 

NOTE: #NUM! – Error occurs if,

  • supplied inumber argument is not recognized as a complex number.

previous-small IMLOG2                                                                                                           next_small IMLOG2