Purpose
Get real coefficient of complex number
Return value
Real coefficient as number
Syntax
=IMREAL(inumber)- inumber - A complex number.
How to use
The IMREAL function returns the real coefficient of a complex number in a format like x + yi or x + yj. For example:
=IMREAL("5+3i") // returns 5
In the example shown, the formula in C6, copied down, is:
=IMREAL(B6)
Notes:
- Only lowercase "j" and "i" are accepted by IMREAL. Other values will result in the #NUM error.
Related functions
COMPLEX Function
The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.
