How to Use the IMPRODUCT Function in Excel
Here you will find a comprehensive guide on utilizing the IMPRODUCT function in Microsoft Excel and Google Sheets.
Overview
The IMPRODUCT function is designed to multiply complex numbers. A complex number is any number that can be represented in the format a + bi, where “a” and “b” are real numbers, and “i” represents the imaginary unit, the square root of -1.
Syntax
The IMPRODUCT function follows the same syntax in both Excel and Google Sheets:
=IMPRODUCT(inumber1, [inumber2], ...)
inumber1
: The first complex number or a cell range containing complex numbers that will be multiplied.inumber2
(optional): Additional complex numbers that are to be multiplied. You can include as many additional complex numbers as required.
Examples
Below are several examples to illustrate how the IMPRODUCT function can be used effectively.
Example 1: Multiply Two Complex Numbers
Consider two complex numbers located in cells A1 and B1. To multiply these numbers, employ the formula:
=IMPRODUCT(A1, B1)
Example 2: Multiply Multiple Complex Numbers
To multiply three complex numbers situated in cells A1, B1, and C1, the formula would be:
=IMPRODUCT(A1, B1, C1)
Example 3: Using Constant Values
It’s also possible to directly input complex number constants into your formula. For example, to multiply the complex numbers 2+3i and 4+2i, you would write:
=IMPRODUCT("2+3i", "4+2i")
Notes
- If any argument is not recognized as a valid complex number, the IMPRODUCT function will return a #NUM! error.
- The outcome of the IMPRODUCT function remains a complex number.
Utilizing the syntax and examples provided, you can adeptly apply the IMPRODUCT function in both Microsoft Excel and Google Sheets to handle multiplication of complex numbers.
More information: https://support.microsoft.com/en-us/office/improduct-function-2fb8651a-a4f2-444f-975e-8ba7aab3a5ba