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.
The real part of the return value is a very small number close to zero.
For practical purposes, it can be interpreted as just"i".
If the input is not a valid complex number, IMSQRT will return the#NUM!Error.
The complex number must be in the form x + yi or x + yj.
Use theCOMPLEX functionto create a complex number from real and imaginary parts.
IMABS Function
The Excel IMABS function returns the absolute value of a complex number.
IMARGUMENT Function
The Excel IMARGUMENT function returns the angle of a complex number expressed in radians.
COMPLEX Function
The Excel COMPLEX function returns the string representation of a complex number.
