Using the Excel IMAGINARY Function
SummaryThe 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.
Required. Complex number for which you want to find the imaginary coefficient.
Usage NotesIMAGINARY 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.