fx =PRODUCT(A1:A10)ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

PRODUCT Formula for Math

Multiply all numbers in a range. Copy-paste ready for Excel, Google Sheets, and Airtable.

=PRODUCT(A1:A10)
When you need this: When you calculate compound growth: 3 years with growth rates 1.05, 1.08, 1.03 → final multiplier.

How it works

  1. 1PRODUCT multiplies all values in a range (A1:A10).
  2. 2Equivalent to A1 × A2 × A3 × ... × A10.
  3. 3Useful for compound calculations and factorial-like operations.

Variations

Compound growth calculation
=PRODUCT(A1:A3)
PRODUCT with condition
=PRODUCT(IF(A1:A10>0,A1:A10,1))

Related Formulas

SUM — Add up a range of numbersMathSUMIF — Sum values that meet a single conditionMathSUMIFS — Sum values meeting multiple conditionsMathROUND — Round a number to specified decimal placesMath

Need a formula that's not here?

Generate custom formula →