If you do any engineering calculations that involve complex numbers, you’ll probably appreciate the complex number functions that are built into Excel. Excel has many functions for working with complex numbers, but we’ll only cover a few here.

Function |
Description |

COMPLEX |
Creates a complex number |

IMAGINARY |
Extracts the imaginary coefficient from a complex number |

IMREAL |
Extracts the real coefficient from a complex number |

IMDIV |
Divides complex numbers |

IMPRODUCT |
Multiplies complex numbers |

IMSUB |
Subtracts complex numbers |

IMSUM |
Adds complex numbers |

You can browse through the other functions for complex numbers by going to **Formulas **> **More Functions **> **Engineering**. Scroll down to find the functions that begin with “IM.” Hover over each function to get a brief description. You can also see the Excel help for more information.

The **COMPLEX **function takes real and imaginary coefficients and creates a complex number, either in **x+yi** or **x+yj** form. The syntax is as follows:

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

COMPLEX(real_num, i_num, [suffix])

real_num: the real part of the complex number (x)

i_num: the imaginary part of the complex number (y)

suffix: (optional) suffix for the imaginary part – either “i” (default) or “j”

If you omit the suffix, Excel will use i by default. It’s important to enclose “i” and “j” in double quotation marks in the suffix argument.

The **IMAGINARY **function can be used to find the imaginary part of an existing complex number – **y** in **x+yi** – and returns it to a cell. There’s only one argument for this function – the complex number. The **IMREAL **function will extract the real part of a complex number (**x**).

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

You can’t directly add, subtract, multiply, or divide complex numbers in Excel using symbols (+, -, etc). To perform those operations with complex numbers, you’ll need to use these special functions: **IMDIV**, **IMPRODUCT**, **IMSUB **and **IMSUM**.

A common example in engineering that uses complex numbers is an AC circuit. In Worksheet 03j, there’s an example that calls for complex number arithmetic:

First, enter in the specified voltage (45+10j) as a complex number. The real part of the voltage is 45 – this will be the first argument. The imaginary part is 10, the second argument. We’ll specify “j” in the third argument so as to not confuse “i” with current. Therefore, the entry for voltage will be **=COMPLEX(45,10,”j”)**. Excel will display this as 45+10j. Do likewise for impedance: **=COMPLEX(3,4,”j”)**.

We need to divide voltage by impedance to find the current, but it’s not possible to simply divide the two complex numbers with the / operator. Use the **IMDIV **function. This function takes the numerator as its first argument, and the denominator as its second. Therefore, to find the current, enter **=IMDIV(C6,C7)**. Remember to separate the two arguments with a comma, not a slash.

This returns a result of 7-6j for the current.

To learn how to format complex numbers in Excel, check out this post.

To learn how to handle matrix calculations with complex numbers, go here.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]