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:
=IMAGINARY(B6)
Notes:
- Only lowercase "j" and "i" are accepted by IMAGINARY. Other values will result in the #NUM error.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.