How to Use {COMPLEX Function} in MS Excel 365?
Tags: complexfunctioninexc, excelfunctions
Published: 2020-08-21 17:00:43

---
title: How to Use {COMPLEX Function} in MS Excel 365?
published: true
date: 2020-08-14 12:38:22 UTC
tags: COMPLEXFunctioninExc,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-complex-function-in-ms-excel-365/
---

## COMPLEX Function in Excel:

Here we come up with the **COMPLEX Function in Excel 365** with its syntax, description, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
 

## **COMPLEX- Function Description:**

- This function will convert a real and imaginary coefficient into a complex number in the form of a+bi.
- Where a and b is a real number. “i or j” is an imaginary number.
- **a** is a **real** part, **bi** is an **imaginary** part.
- The sample complex numbers are 2+3i, 4-2i.

## **Basic Syntax:**

**=COMPLEX(real\_num, i\_num, [suffix])**

### Parameters Description:

**Real\_num** – It is the real coefficient of the complex number.

**I\_num** – It is the imaginary coefficient of the complex number.

**suffix** – This is optional. It is the suffix for the imaginary component of the complex number. If it is not mentioned, it will assign “i” automatically.

### **Note:**

- If either a real\_num or i\_num is a non-numeric, it returns **#VALUE!** Error.
- If the suffix is neither “ **i** ” nor “ **j** “, it returns **#VALUE!** Error.

## **Examples:**

Let’s see some examples to understand this concept.

### Example 1:

- Refer to the below image.
- Here we have mentioned the real, imaginary, and suffix in the **Columns A** , **B** , and **C**.
- The converted complex numbers have been listed in **Column D**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-31.png)<figcaption id="caption-attachment-11713">Example 1</figcaption>

### Example 2:

- If either a real\_num or i\_num is a non-numeric, it returns **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-22.png)<figcaption id="caption-attachment-11715">Example 2</figcaption>

### Example 3:

- If the suffix is neither “i” nor “j”, it returns **#VALUE!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-20.png)<figcaption id="caption-attachment-11716">Example 3</figcaption>

## **Summary:**

In this article, you can learn how to use **COMPLEX Function in Excel 365** with its syntax, description, and examples. Kindly, give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- **IMSUB Function in Excel 365**
- **IMPOWER Function**
- **IMPRODUCT Function**
- **IMREAL Function**

### Keep Reading:

- [How to Use “BITAND Function” in Excel 365? – { with Examples }](https://geekexcel.com/how-to-use-bitand-function-in-excel-365-with-examples/)
- [How to Use DELTA Function in Microsoft Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-delta-function-in-microsoft-excel-365-with-examples/)