**Excel** from **Microsoft** is, without a doubt, a powerful software. Using Excelâ€™s tools and capabilities, we can carry out continuous operations on whatever dataset we want. In addition to this, Excel provides a plethora of helpful Library Functions. This article will cover understanding the internal workings of Excelâ€™s** COMPLEX** Function as well as explain how it runs independently. In addition, we will analyze two real-world situations to get a more in-depth knowledge of the **COMPLEX** Function. Therefore, you should use these 2 practical examples to **Use Excel COMPLEX Function**.

**Table of Contents**hide

## Download Practice Workbook

You can get a free copy of the sample workbook we discussed throughout the presentation by clicking on the link below.

## Introduction to COMPLEX Function in Excel

**Summary**

Microsoft Excelâ€™s **COMPLEX** function combines real and imaginary components together into complex values. In particular, the complex number format can be both **X + Yi** and **X + Yj**. Excelâ€™s **COMPLEX** function belongs to the Engineering Functions category.

**Syntax**

`=COMPLEX(real_num,i_num,[suffix])`

**Arguments**

ARGUMENT | REQUIRED/OPTIONAL | EXPLANATION |
---|---|---|

real_num |
Required | The complex numberâ€™s Real coefficient. |

i_num |
Required | The complex numberâ€™s Imaginary coefficient. |

suffix |
Optional | The ending for the imaginary part of a complex number. If not given, the suffix is assumed to be i. |

**Version**

The **COMPLEX** function is available in all versions of Microsoft Excel.

## 2 Practical Examples of Using Excel COMPLEX Function

To demonstrate the point, letâ€™s look at a representative dataset. The following dataset has three columns for illustration: **Real Coefficient**, **Imaginary Coefficient**, and **Suffix**. Particularly, this article will investigate each real scenario using the** COMPLEX** Function. In the first part of this course, We will use the **COMPLEX** function to depict the Imaginary number series. On the other hand, a different example will cover the investigation of the **COMPLEX** function in the context of its use as a parameter in other functions. In addition, I created my essay using **Microsoft Excel 365**, which I should have done. Nevertheless, you can choose the variant that caters to your requirements effectively.

### 1. Display Imaginary Number Through COMPLEX Function in Excel

The first and foremost example of the **COMPLEX** function covered in this post is showing the Imaginary numbers. The** COMPLEX** function will take two required values as well as a suffix to show a **COMPLEX **number. The function returns an imaginary number if the real and imaginary parameters are numbers. On the other hand, If not, **COMPLEX **returns the **#VALUE** Error. A suffix parameter is an option. Kindly follow these instructions carefully to finish the work.

**ðŸ“Œ Steps:**

- First of all, select the
**E5**cell. - Second, write the formula below in
**E5**.

`=COMPLEX(B5,C5,D5)`

- After that, hit
**Enter**or**TabÂ**key. - Subsequently, it will provide the intended out.

- Now, use the
**Fill Handle**icon as well as move it to**E10**to apply the same formula in other cells. - As a result, the desired output will display as below.

**Read More: ****How to Add Complex Numbers in Excel (With Easy Steps)**

### 2. Utilize COMPLEX Function to Create Parameters for Some Other Functions

In this section of the study of the **COMPLEX** function, we will also analyze a second compelling and practical example. The **COMPLEX** function may be used as a parameter for another function. Here, we will see how the **IMARGUMENT** Function, as well as the**Â IMCONJUGATE** Function, use the COMPLEX function to accept parameters. It is important to note that these functions accept only imaginary values as input arguments. The **IMARGUMENT** function returns the angle in radians of the provided imaginary expression. In contrast, the **IMCONJUGATE** function in **Microsoft Excel** generates the conjugate of a complex value. You must carefully follow these directions to accomplish the task.

**ðŸ“Œ Steps:**

- First of all, pick cell
**E5**. - Second, write the formula below in
**E5**.

`=IMARGUMENT(COMPLEX(B5,C5,D5))`

- Later, tap
**Enter**or**TabÂ**key. - Due to this, it will provide the outcome as follow.

- Then, use the
**Fill Handle**icon. - Not only hold the Fill Handle symbol but also move it to
**E10**to use the same formula in other cells. - Subsequently, the desired output will display below.

- Latterly, choose the
**F5Â**cell. - After that, type the following formula in
**F5**.

`=IMCONJUGATE(COMPLEX(B5,C5,D5))`

- Next, press the
**Enter**or**TabÂ**key. - Consequently, The below will be the output.

- Like previously, utilize the
**Fill Handle**symbol to the same formula in other cells. - To achieve this, essentially hold the icon.
- After that, move the
**Fill Handle**icon to cell**F10**. - As a result, we will find the desired outcome below.

**Read More: ****How to Convert Complex Numbers to Polar Form in Excel**

## Common Errors While Using Excel COMPLEX Function

Common Errors | When They Show |
---|---|

#VALUE! |
If real_num is not a number, the COMPLEX gives the error value #VALUE! Error. |

#VALUE! |
The COMPLEX returns the #VALUE! error number if i_num is not a numeric value. |

#VALUE! |
The COMPLEX Functions only accept I and J in Lowercase as the suffix value. Using all Capital Letters yields the #VALUE! Error value. |

## Conclusion

From now on, you can use the **COMPLEX** function in **Excel** after learning and seeing how it works in the examples we discussed. Moreover, on the **ExcelDemy Website**, you can find many articles like this. Keep using this, and let us know if you have any new ideas or other ways to get the job done. Last but not least, remember to leave comments, questions, or ideas in the section below.