In this article, you will learn about the IMREAL function, its usage, syntax and how to use it in your excel spreadsheet.
IMREAL Function in Excel
The IMREAL function in Excel returns the real coefficient of a complex number in x + yi or x + yj text format.
Syntax
= IMREAL(inumber)
Arguments:
- Inumber – A complex number for which you want the real coefficient.
Possible Errors and Usage Notes
- The IMREAL function accepts only lowercase “j” and “i”, other values will result in the #NUM error.
How to use the IMREAL function in Excel?
Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.
Take a look at the given example
To find out the real coefficient of the complex numbers, Enter the complex numbers in column A and enter the following formula in Column B,
Formula: =IMREAL (A1)
Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the real coefficient of the complex form.
