For example:
Excel handles complex numbers as strings formatted like “x+yi” or “x+yj”.
Use theCOMPLEXfunction to get the string representing a complex number.
IMREAL Function
The Excel IMREAL function returns the real part of a complex number.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.
IMSUM Function
The Excel IMSUM function returns the sum of two or more complex numbers.
IMPRODUCT Function
The Excel IMPRODUCT function returns the product of one or more complex numbers.
