For example, given the complex number “3+4i” the function returns the angle 0.927295218.
To convert the angle to degrees, use the DEGREES function.
For example, consider the complex number “-5-5i” in the complex plane.
The IMARGUMENT function always returns angles in the range from - to radians.
For the complex number “-5-5i” the function returns the angle -3/4 .
For complex numbers that lie on the negative real axis, the function returns radians.
In other words, the range excludes - and includes .
COMPLEX Function
The Excel COMPLEX function returns the string representation of a complex number.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.