Excel IMAGINARY Function

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

  1. Click on an empty cell (like F5).
empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select ENGINEERING category.

5. Select IMAGINARY function

6. Then select ok.

excel IMAGINARY function

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.

How to use IMAGINARY function in excel

Examples of IMAGINARY function in Excel

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.

Leave a Reply

Your email address will not be published. Required fields are marked *