IMAGINARY Function in Excel – Get the imaginary coefficient of a complex number

IMAGINARY Function in Excel returns the imaginary coefficient of a complex number.

Imaginary coefficient of complex number is the coefficient of value i.The imaginary coefficient of the complex number, z = x + iy is y

 

Syntax of IMAGINARY Function in Excel 

IMAGINARY ( inumber )

Where inumber argument is a Complex Number.

 

Example of IMAGINARY Function in Excel

Formula

IMAGINARY Function in Excel 1

  • From Row number 2 to 5 IMAGINARY Function takes up complex number as a reference
  • In row number 6, IMAGINARY Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes
  • In row number 7, IMAGINARY Function takes up real component as a value which returns 0 since there is no imaginary component. 

Result

IMAGINARY Function in Excel 2

NOTE: #NUM! – Error occurs if,

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

previous-small IMAGINARY Function in Excel                                                                                                           next_small IMAGINARY Function in Excel