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.
Arguments can be hard-coded values, cell references, or a range.
Let’s visualize another example.
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.
IMDIV Function
The Excel IMDIV function returns the quotient of two complex numbers.
IMPOWER Function
The Excel IMPOWER function returns a complex number raised to a given power.
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.
