IMPRODUCT
TheIMPRODUCT
function in Google Sheets returns the product of multiple complex numbers. It takes in one or more complex numbers as input arguments and calculates their product. Complex numbers must be entered in the format a+bi, where a is the real part and b is the imaginary part. This function is commonly used in engineering and scientific applications.
 How to use
IMPRODUCT
formula?  Examples of using
IMPRODUCT
formula IMPRODUCT
formula not working? Similar formulas to
IMPRODUCT
Usage
Use the IMPRODUCT
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 factor1 (required):
The first complex number or range of complex numbers to be multiplied.  factor2, ... (optional):
Optional. Additional complex numbers or ranges of complex numbers to be multiplied.
Examples
Here are a few example use cases that explain how to use theIMPRODUCT
formula in Google Sheets.
Multiplying two complex numbers
To multiply two complex numbers, simply enter them as the arguments to the IMPRODUCT
function.
Multiplying a range of complex numbers
To multiply a range of complex numbers, enter the range as the argument to the IMPRODUCT
function.
Calculating impedance
In electrical engineering, the IMPRODUCT
function can be used to calculate the impedance of a circuit. The complex numbers represent the resistance and reactance of the circuit components.
Common Mistakes
IMPRODUCT
not working? Here are some common mistakes people make when using the IMPRODUCT
Google Sheets Formula:
Incorrect number of arguments
One of the most common mistakes is providing an incorrect number of arguments to the IMPRODUCT formula. Make sure you specify at least one factor and separate multiple factors with commas.
Invalid data type
IMPRODUCT only works with numerical values. If you provide a nonnumerical value as an argument, the formula will return an error. Doublecheck that all of your arguments are numerical values.
Using a range reference
IMPRODUCT doesn't work with range references. If you need to calculate the product of a range of cells, you can use the PRODUCT formula instead.
Forgetting to close parentheses
Make sure you close all of the parentheses in your formula. Forgetting to close a parentheses can cause the formula to return an error.
Using a blank cell reference
If one of the arguments for IMPRODUCT is a blank cell, the formula will return 0. Make sure you're not accidentally referencing a blank cell in your formula.
Related Formulas
The following functions are similar to IMPRODUCT
or are often used with it in a formula:

IMSUM
The
IMSUM
function returns the sum of complex numbers. It can take up to 255 complex number arguments. It is commonly used in engineering and scientific applications where complex numbers are used. 
IMABS
The
IMABS
function returns the absolute value (modulus) of a complex number. This is useful when working with complex numbers in engineering or scientific calculations. 
IMARGUMENT
The
IMARGUMENT
function returns the argument corresponding to the given number in a complex number in rectangular form.
Learn More
You can learn more about the IMPRODUCT
Google Sheets function on Google Support.