Exceljet

Quick, clean, and to the point

Excel IMREAL Function

Excel IMREAL function
Summary 
The Excel IMREAL function returns the real coefficient of a complex number in the form x + yi or x + yj.
Purpose 
Get real coefficient of complex number
Return value 
Real coefficient as number
Syntax 
=IMREAL (inumber)
Arguments 
  • inumber - A complex number.
Usage notes 

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.