Using the Excel IMAGINARY Function

Summary
The Excel IMAGINARY function returns the imaginary coefficient of a complex number in such text format as x + yi or x + yj.Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
Syntax
=IMAGINARY (inumber)Syntax Breakdown
InumberRequired. Complex number for which you want to find the imaginary coefficient.
Usage Notes
IMAGINARY returns the imaginary coefficient of a complex number.The function will return the #NUM! error if a value besides "i" or "j" is entered in the argument.