List of Complex Functions in Excel (10+ Functions)

Get FREE Advanced Excel Exercises with Solutions!

A complex number is a combination of real numbers and imaginary numbers represented in x+iy format. Where x is the real part and y is the coefficient of the imaginary part. In Excel, there are some functions to deal with complex numbers located in the Engineering functions category.

In this tutorial, you will learn how to use 11 complex number functions in Excel with proper examples and illustrations.

Here’s an overview of the application of some complex number functions in Excel.

1-Overview of Excel complex functions


11 Complex Functions in Excel

1. COMPLEX Function

The COMPLEX function returns a complex number from real and imaginary coefficients. It maintains the form of x + yi or x + yj.

The syntax of the COMPLEX function is:

COMPLEX(real_num, i_num, [suffix])

In the below dataset, there are some real coefficient in range B6:B10 and imaginary coefficients in C6:C10.

  1. Insert the following formula in cell D6 to return the corresponding complex number: =COMPLEX(B6,C6)
  2. Then used the Fill Handle tool to copy the formula for the other cells.2-Using Excel COMPLEX function

Note: All complex number functions accept “i” and “j” for suffixes, but neither “I” nor “J”.

2. IMREAL Function

The IMREAL function returns the real part of a complex number that is in x + yi or x + yj format.

The syntax of the IMREAL function is:

IMREAL(inumber)

In our below dataset, there are some complex numbers within range B6:B10.

The formula for the real part using the IMREAL function in cell C6 is: =IMREAL((B6))

3-Using Excel IMREAL function

3. IMAGINARY Function

The IMAGINARY function is used to calculate the imaginary coefficient of a complex number.

The syntax of the IMAGINARY function is:

IMAGINARY(inumber)

To obtain the imaginary component of the complex number in cell B6, the formula in cell C6 is: =IMAGINARY((B6))

4-Using Excel IMAGINARY function

4. IMABS Function

The IMABS function is used to return the absolute/modulus value of a complex number in x + yi or x + yj text format.

The syntax of the IMABS function is:

IMABS(inumber)

We applied the following formula to cell C6 to return the absolute value for the complex number of cell B6: =IMABS(B6)

5-Using Excel IMABS function

5. IMARGUMENT Function

The IMARGUMENT function is used to return the angle/theta() of a complex number in radians.

The syntax of the IMARGUMENT function is:

IMARGUMENT(inumber)

To return the argument of the complex number of cell B6, we used this formula in cell C6: =IMARGUMENT((B6))

6-Using Excel IMARGUMENT function

6. IMCONJUGATE Function

The IMCONJUGATE function is used to return the complex conjugate of a complex number in x + yi or x + yj text format.

The syntax of the IMCONJUGATE function is:

IMCONJUGATE(inumber)

Here’s the formula to return the conjugate complex number in cell C6: =IMCONJUGATE(B6)

7-Using Excel IMCONJUGATE function

7. IMSUM Function

The IMSUM function is used to add multiple complex numbers in Excel. Remember, the complex number’s format will have to be in x + yi or x + yj format.

The syntax of the INSUM function is:

IMSUM(inumber1, [inumber2], …)

In the below dataset, there are some complex numbers within the range B6:C10.

To sum the complex numbers from cells B6 and C6, the formula in cell D6 is: =IMSUM(B6,C6)

8-Using Excel IMSUM function

8. IMSUB Function

To return the difference between two complex numbers, the IMSUB function is used in Excel.

The syntax of the IMSUB function is:

IMSUB(inumber1, inumber2)

To subtract the complex number of cell C6 from the complex number of cell B6, the formula in cell D6 is: =IMSUB(B6,C6)

9-Using Excel IMSUB function

9. IMPRODUCT Function

The IMPRODUCT function in Excel is used to return the output of multiplying complex numbers. The numbers must have to be formatted in x + yi or x + yj.

The syntax of the IMPRODUCT function is:

IMPRODUCT(inumber1, [inumber2], …)

The formula in cell D6 to multiply the complex numbers from cells B6 and C6 is: =IMPRODUCT(B6,C6)

10-Using Excel IMPRODUCT function

10. IMDIV Function

To divide one complex number by another complex number, Excel’s IMDIV function is used.

The syntax of the IMDIV function is:

IMDIV(inumber1, inumber2)

To divide the complex number of cell B6 by the complex number of cell C6, we used the formula in cell D6: =IMDIV(B6,C6)

11-Using Excel IMDIV function

11. IMPOWER Function

To return a complex number raised by a specific power, the EMPOWER function is used in Excel.

The syntax of the EMPOWER function is:

IMPOWER(inumber, number)

In the below dataset, there are some complex numbers in the range B6:B10 and powers in the range C6:C10.

The formula to return the complex number raised by the given power in cell D6 is: =IMPOWER(B6,C6)

12-Using Excel IMPOWER function


Download Practice Workbook


Conclusion

Complex numbers are mostly used in the fields of physics, mathematics, engineering, and many more. By using the Excel complex number functions, you will be able to apply them to different kinds of complex calculations with automation. So practice more and increase your productivity.

Thanks for reading the article. If you have any further queries, please let us know in the comment section.


<< Go Back to Excel Function Categories | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo