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.
= IMPRODUCT (inumber1, [inumber2], ...)
- Inumber1, [inumber2], … – Where Inumber1 is mandatory, and subsequent inumbers are not necessary. The argument can extend from 1 to 255 complex numbers to multiply
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
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.