How to Use IMPRODUCT Function in Excel 365? – [with Examples]
Tags: excelfunctions, improductfunctionine
Published: 2020-08-21 16:38:39

---
title: How to Use IMPRODUCT Function in Excel 365? – [with Examples]
published: true
date: 2020-08-14 11:59:09 UTC
tags: ExcelFunctions,IMPRODUCTFunctioninE
canonical_url: https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/
---

## IMPRODUCT Function in Excel:

This guide will show you how to use **IMPRODUCT Function in Excel 365** with its syntax, explanation, and examples. Let’s get started!! 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)

 ## **IMPRODUCT – Function Explanation:**

- This function **returns the product of one or more complex numbers** (1 – 255 complex numbers).
- It will return the result in the form of a complex number.
- Generally, a complex number is in the form of ( **X±Yi** ) or ( **X±Yj** ).
- X and Y are real numbers, and i or j is an imaginary number.
- **X** is a **real** part, **Yi** is an **imaginary** part.
- For example, (2+3i), (6-2i) like that.

## **Syntax:**

=**IMPRODUCT(inumber, [inumber2],…)**

### Argument Explanation:

**inumber** – It is a complex number 1.

**inumber**  **2** – It is optional. This is a second Complex number (1 – 255 complex numbers to multiply).

### The product of two complex numbers is calculated as follows:

**( a + bi )( c + di )= (ac – bd )(ad+bc)i**

### **Note:**

- You can use the COMPLEX function to convert real and imaginary coefficients to a complex number.
- If the number is a non-numeric value ( **letters and special characters** ), it returns **#NUM!** Error.
- Only “i” or “j” is allowed to use in this function, other values will return **#NUM!** Error.

## **Examples:**

Let’s see some examples.

**Example 1:**

- Refer to the below image.
- Complex number 1 is listed in **Column A** , complex number 2 is listed in **Column B**.
- The product of two complex numbers is listed in **Column C**.

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

### Example 2:

- Only “i” or “j” is allowed to use in this function, other values will return **#NUM!** Error.

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

### Example 3:

- If the number is a non-numeric value ( **letters and special characters** ), it returns **#NUM!** Error.

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

## **Bottom-Line:**

In this article, you can understand the usage of **IMPRODUCT Function in Excel 365** with its basic syntax, description, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- **IMSUM Function**
- **IMSUB Function**
- **IMPOWER Function**

### Read Also:

- [How to Use “HEX2DEC Function” in Microsoft Excel 365?](https://geekexcel.com/how-to-use-hex2dec-function-in-microsoft-excel-365/)
- [How to Use HEX2BIN Function in MS Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-hex2bin-function-in-ms-excel-365-with-examples/)