Formulas > =IMPRODUCT()

How to Use IMPRODUCT() in Google Sheets

Description

Returns the result of multiplying a series of complex numbers together.

How To Actually Use IMPRODUCT() in Sheets

IMPRODUCT(factor1, [factor2, ...])

Try IMPRODUCT yourself

In cells A1 to A5, enter a series of complex numbers (e.g., 1+2i, 3+4i). Use the IMPRODUCT formula to multiply these complex numbers together in cell B1.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for IMPRODUCT(). Click through to watch.

Watch more tutorials
Hardest Formula: SumIF | Addition Based on Dates / Values

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...
Write Apps Script to Create a New Google Sheets Formula

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Learn more about the IMPRODUCT() formula:

Generate a IMPRODUCT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses IMPRODUCT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a IMPRODUCT() formula
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.