PRODUCT Function
Multiplies together all supplied numbers.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| number1 | The first number, range, or cell reference to multiply. | Required |
| number2 | Additional numbers, ranges, or references (optional). Up to 255 arguments. | Optional |
Basic Example
Multiply a few values
=PRODUCT(2, 3, 4)2 × 3 × 4 = 24.
Advanced Examples
Example 1: Multiply an entire range
Product of cells A1:A3 containing 2, 3, 4.Reference a range directly.
=PRODUCT(A1:A3)Example 2: A zero anywhere zeroes the product
Mixed values including 0.Show the effect of a zero factor.
=PRODUCT(2, 0, 5)How PRODUCT Works
PRODUCT multiplies all numeric values across its arguments. Empty cells, text, and logical values in ranges are ignored, but explicitly typed TRUE/FALSE and numbers are multiplied. Supplying zero yields zero.
Important Notes & Limitations
Empty cells, text, and logical values inside ranges are ignored (unlike explicitly entered TRUE/FALSE).
A single zero factor makes the entire product zero.
Extremely large products overflow to #NUM!.
Common Errors & Fixes
#NUM!The product is too large to represent.Fix: Use logarithms (EXP(SUMPRODUCT(LN(range)))) or scale the inputs.
Result is 0 unexpectedlyA zero is present in the data.Fix: Inspect the range for zeros or use an array formula that excludes them.
Download Practice File
PRODUCT
productPractice PRODUCT with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the PRODUCT function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps