What is IMAGINARY function in Excel?
The IMAGINARY function is one of the Engineering functions of Excel.
It Returns the imaginary coefficient of a complex number.
We can find this function in Engineering of insert function Tab.
How to use IMAGINARY 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 IMAGINARY function
6. Then select ok.

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

Examples of IMAGINARY function in Excel

IMAGINARY related functions
- Use COMPLEX function to convert real and imaginary coefficients into complex numbers
- Use IMABS function to return the absolute value of a complex number.
- Use IMREAL function to return the real coefficient of a complex number.
- Use IMDIV function to return the quotient of two complex numbers.