What is IMREAL function in Excel?
The IMREAL function is one of the Engineering functions of Excel.
It Returns the real coefficient of a complex number.
We can find this function in ENGINEERING category of the insert function Tab.
How to use IMREAL function in excel
- Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select ENGINEERING category.
5. Select IMREAL function
6. Then select ok.

7. In the function arguments Tab you will see IMREAL function.
8. Inumber section is a complex number for which you want the real coefficient.
9. You will see the results in the formula result section.

Examples of IMREAL function in Excel

IMREAL related functions
- Use COMPLEX Function to convert real and imaginary coefficients into complex numbers.
- Use IMAGINARY Function to return the imaginary coefficient of a complex number.
- Use IMSUM function to return the sum of complex numbers.