IMPRODUCT

The IMPRODUCT function in Google Sheets returns the result of multiplying a series of complex numbers together.

Parameters

• factor1: The first complex number or range to include in the product.
• factor2, ...: [Optional] Additional complex numbers or ranges to include in the product.

Step-by-Step Tutorial

1. Using IMPRODUCT with individual complex numbers:

   • Example: =IMPRODUCT(2+3i, 4+5i)
   • Result: (2+3i) * (4+5i) = (-7+22i)

2. Using IMPRODUCT with a range of cells:

   • Example: If A1:A3 has the complex numbers (2+3i), (4+5i), (-1-2i), then =IMPRODUCT(A1:A3) will return (2+3i) * (4+5i) * (-1-2i) = (50-29i).

Working with a Single Value, a List, and a Range

IMPRODUCT accepts complex numbers one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =IMPRODUCT(A1) — just returns the complex number in A1.
• List of values: =IMPRODUCT(A1, A2) — multiplies each cell individually. If A1 is 1+1i and A2 is 2+0i, the result is 2+2i.
• Range: =IMPRODUCT(A1:A3) — multiplies every complex number in the range. If A1:A3 holds 1+1i, 2+0i, 1-1i, the result is 4.
• Mixed: =IMPRODUCT(A1, A3:A4) — you can combine single cells and ranges in one call.

Use Cases and Scenarios

1. Electrical Engineering: Calculate the product of impedance values in a circuit.
2. Signal Processing: Multiply complex numbers to analyze signal characteristics.
3. Financial Analysis: Perform complex number operations in financial models.

Related Functions

None.

Related Articles

None.