IMPRODUCT Function in Excel

In this article, you will learn about the IMPRODUCT function, its usage, syntax and how to use it in your excel spreadsheet.

IMPRODUCT Function in Excel

The IMPRODUCT function in Excel returns the product of one or more complex numbers.  This function can handle from 1 to 255 complex numbers.

Syntax

= IMPRODUCT (inumber1, [inumber2], ...)

Arguments:

  • Inumber1, [inumber2], …    – Where Inumber1 is mandatory, and subsequent inumbers are not necessary. The argument can extend from 1 to 255 complex numbers to multiply

Mathematical Equation

Excel does the calculations internally for multiplying two or more complex numbers, but it is necessary to understand the mathematical equation behind this calculation.

Equation: (a+bi)(c+di) = (ac-bd)+(ad+bc)i

How to use the IMPRODUCT function in Excel?

Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

How to use the IMPRODUCT function in Excel?

To obtain the product of two or more complex numbers, Enter the complex numbers in columns A, B and C and in Column D enter the following formula

Formula: =IMPRODUCT (A1,B1,C1)

Excel does the mathematical calculation internally and returns the result.

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the product of the complex numbers.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.