The IMREAL function is used to extract the real coefficient of a complex number.

## Contents:

## Syntax

`= IMREAL(`*complex_number*)

*complex_number -* This is the complex number for which you want to find the absolute value. It can be supplied as a string (like "3+4i") or as a reference to a cell containing the complex number.

### Explanation

The IMREAL function is part of the "Engineering" group of functions within Excel.

This function is used to extract the real part of a complex number.

A complex number is usually in the form 'a + bi' or sometimes 'a + bj', where **a** is the real part or coefficient, **b** is the imaginary part, and **i** or **j** is the imaginary number or unit.

So, in the complex number '9+3i', the real coefficient would be 9.

### Examples

## How to Extract the Real Coefficient of a Complex Number

Let's say we have table with complex numbers, and need to pull out the imaginary components of each number.

Without the IMREAL function, we would have to use a complicated formula to extract the real part of each cell. But, with the IMREAL function, we can simply type:

`= IMREAL(A2)`

To extract the real coefficient from a complex number held in cell A2.

So if we put that formula alongside our table and reference the complex numbers, we get something that looks like this:

Here, with the IMREAL formula in the second column, we can see that the real parts of each complex number are returned correctly.