IMREAL Function

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.

IMREAL plays the same extraction role for the real side of a complex value. It is helpful in models that mix complex-number calculations with ordinary reporting, because it lets the workbook pull out the part that should behave like a standard number in downstream formulas.

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.

In this example, the real part is 3 and the imaginary part is 4, so the formula returns 3. It is the simplest way to see exactly what IMREAL keeps and what it ignores.

=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.

So the example is not only about getting the value 50. It also shows that the notation style does not change what IMREAL can extract.

=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.

This makes the example useful for interpretation. It reminds the learner that IMREAL does not clean up or simplify the number. It returns the real component exactly as written.

=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.

That makes the example helpful for beginners because it shows a clean edge case. When there is no real part at all, the function gives zero instead of guessing or returning an error.

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

Conclusion Recap

IMREAL is the matching extraction tool for the real side of a complex number. In this lesson, the key idea was that the function reports only the value on the real axis, whether the input is mixed, purely real, or even purely imaginary.

That is why IMREAL is useful in models that mix complex and ordinary numeric work. Once the real component is separated out, Excel can treat it like any other normal number, which makes comparisons and downstream calculations much easier to manage.

• 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.