ID EN
#Engineering

IMREAL

Excel Functions

Get real part of a complex number

Syntax

EXCEL
=IMREAL(inumber)

Arguments

Parameter Description
inumber A string representing a complex number.

Return Value

The real part of a complex number

Details

The IMREAL function returns the real part of a complex number. For example: 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.

Examples

Example 1

The IMREAL function returns the real part of a complex number. For example:

EXCEL
=IMREAL("4+3i") // returns 4
Explanation

The IMREAL function returns the real part of the number.

EXCEL
=IMREAL("2-5i") // returns 2

See Also

COMPLEX IMAGINARY IMABS IMARGUMENT