Purpose
Return value
Syntax
=IMREAL(inumber)- inumber - A string representing a complex number.
How to use
The IMREAL function returns the real part of a complex number. For example:
=IMREAL("4+3i") // returns 4
Explanation
A complex number like "2-5i" is drawn as an arrow in the complex plane, where the horizontal axis corresponds to the real part of the number, and the vertical axis corresponds to the imaginary part.
The IMREAL function returns the real part of the number.
=IMREAL("2-5i") // returns 2
Notes:
- IMREAL returns a #NUM error when the input does not represent a valid complex number.
Related functions
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.
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. The argument, also known as the phase, is the angle between the positive real axis and the line the complex number lies on in the complex plane.
