Summary

IMREAL returns the real part of a complex number. If a cell contains a value like 3+4i, IMREAL gives you just the real side, which is 3.

This is useful when a worksheet stores values as full complex numbers, but a later step only needs the real component. Instead of parsing the text yourself, you can let Excel pull that part out directly.

Syntax

=IMREAL(inumber)

inumber is the complex value you want to read.

The input can be a complex number typed directly, a cell reference, or a result created by COMPLEX(). IMREAL reads that value and returns only the real coefficient as a normal number.

Arguments

• inumber - [required] The complex number you want to read the real part from.

inumber should be a valid Excel complex number such as 6-9i or 6-9j. A purely imaginary input is also valid, and in that case the result is 0 because there is no real part. Using a cell or COMPLEX() result is usually easier than typing the text by hand every time.

IMREAL vs similar functions

IMREAL is for reading one part of a complex value, not building or combining one:

Using IMREAL

The main use is simple. If a cell holds a complex value but your next formula only needs the real side, IMREAL saves you from splitting or cleaning the text manually. That makes the worksheet easier to read and much safer to maintain.

IMREAL keeps the sign of the real part, so a value like -10+5i returns -10. If the number has no real part at all, such as 5i, the result is 0.

Excel supports complex values written with either i or j, but the suffix should stay lowercase. That keeps the input valid for the complex-number functions.

Example 1 - Extract the real part from 3+4i

This is the direct use case for IMREAL. The complex input contains both a real and an imaginary component, but the formula returns only the real coefficient. That is helpful when a later calculation needs the physical or numeric magnitude on the real axis without manually parsing the complex text.

=IMREAL("3+4i") // Returns 3

Example 2 - Read the real part from 50+30j

This example shows that IMREAL is not tied to i-notation. The input uses j, which is common in engineering notation, and Excel still returns the real coefficient correctly. That makes the function practical in sheets that model impedance or other electrical quantities.

=IMREAL("50+30j") // Returns 50

Example 3 - Keep a negative real value

The sign of the real part remains part of the result. Here the formula returns -10, not 10, because IMREAL extracts the real coefficient exactly as it appears in the complex value. That detail matters when the sign carries meaning, such as direction, polarity, or signed model output.

=IMREAL("-10+5i") // Returns -10

Example 4 - Read a pure imaginary value

A value like 5i has no real component, so IMREAL returns 0. This is a useful reminder that the function does not estimate or infer a real part. It simply reports what is present on the real axis of the complex number.

=IMREAL("5i") // Returns 0

Quick recap

• Returns the real part: IMREAL pulls only the real side out of a complex value.
• Returns a number: The result is ready for normal formulas.
• Keeps the sign: Negative real values stay negative.
• Returns 0 for pure imaginary input: If there is no real part, IMREAL gives zero.
• Works with i or j: Both are valid when the input is a proper Excel complex value.