Excel IMREAL Function

Using the Excel IMREAL Function

Excel IMREAL Function

Summary

The Excel IMREAL function returns the real coefficient of a complex number in text format x + yi or x + yj.

Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Syntax

=IMREAL (inumber)

Syntax Breakdown

Inumber
Required. Complex number for which you want to find the real coefficient.

Usage Notes

IMREAL returns the real coefficient of a complex number in text format x + yi or x + yj.

Only use lowercase "j" and "i" in the IMREAL function. Other values result in the #NUM! error.