Google Sheets
PRODUCT function in Google Sheets
Returns the result of multiplying a series of numbers together.
=PRODUCT(factor1, [factor2, ...])PRODUCT syntax and parameters
Two arguments, one required.
- factor1anyRequired
The first number or range to calculate for the product.
- factor2anyRepeating
PRODUCT examples
Formulas you'll actually reuse.
A column of factors multiplied — e.g. chained growth rates:
=PRODUCT(B2:B5)Result
1.2155Price × (1 − discount) × (1 + tax) in one call:
=PRODUCT(B2, 1 - C2, 1 + D2)Result
23.79
PRODUCT in Excel
Same name — your formula ports as-is.
Try PRODUCT in the playground
Edit the example — nothing to install.
Preloaded with the PRODUCT formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel