Exceljet

Quick, clean, and to the point

Excel IMAGINARY Function

Excel IMAGINARY function
Summary 
The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.
Purpose 
Get imaginary coefficient of complex number
Return value 
Imaginary coefficient as number
Syntax 
=IMAGINARY (inumber)
Arguments 
  • inumber - A complex number.
Version 
Usage notes 

The Excel IMAGINARY function returns the imaginary coefficient of a complex number in the form x + yi or x + yj. For example:

=IMAGINARY("5+3i") // returns 3

In the example shown, the formula in D6, copied down, is:

Notes:

  • Only lowercase "j" and "i" are accepted by IMAGINARY. Other values will result in the #NUM error.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.