PRODUCT Function

Summary

The Excel PRODUCT function multiplies all the numbers and cell ranges supplied as arguments. While basic multiplication is often done using the asterisk operator, PRODUCT accepts contiguous ranges and multiple discrete arguments in a single formula, returning a compounded multiplicative total.

PRODUCT is especially valuable in financial modeling, engineering scaling, and probability calculations where several factors or ratios must be combined sequentially. By condensing multi-cell multiplication into one concise expression, it keeps formulas clean, scalable, and resistant to manual reference errors.

Syntax

=PRODUCT(number1, [number2], ...)

PRODUCT requires at least one number, cell reference, or range as number1, and supports up to 254 optional additional arguments. Arguments can blend single cells, numbers, and contiguous ranges in any order.

Arguments

• number1 — [Required] The first number, cell reference, or range to multiply.
• number2, ... — [Optional] Up to 254 additional numbers, references, or ranges to include in the product.

PRODUCT vs Other Functions

Using PRODUCT

PRODUCT is ideal when your data model relies on sequential multipliers such as compound interest factors, tax scaling, volume unit conversions, or chained probabilities. Instead of writing long expressions like =B1*B2*B3*B4*B5, you can simply write =PRODUCT(B1:B5).

One essential characteristic of PRODUCT is how it handles different cell types. When referencing cells, Excel automatically skips empty cells and text strings, preventing calculation errors. However, if any cell in the range contains a numerical 0, the entire product evaluates to zero.

You can also combine ranges with standalone scalar adjustments, making PRODUCT flexible for applying adjustments, discounts, or conversion constants directly to a base series.

Example 1 — Multiply a Range of Numbers

This demonstrates the fundamental use case: multiplying every numeric cell in a continuous vertical range.

=PRODUCT(B1:B4)

If cells B1 through B4 contain 2, 3, 4, and 5, the formula calculates 2 * 3 * 4 * 5 and returns 120.

Example 2 — Multiply Non-Adjacent Cells

You can pass separate cell references when values are located in different parts of the spreadsheet.

=PRODUCT(B1,C1)

If cell B1 contains 2 and cell C1 contains 7, the formula returns 14.

Example 3 — Multiply a Range with a Constant Multiplier

You can supply an explicit constant value alongside a cell range to scale the output.

=PRODUCT(B1:B3,10)

With B1:B3 containing 2, 3, and 4 (product is 24), multiplying by the constant 10 yields 240.

Example 4 — Apply a Dynamic Factor from Another Cell

To avoid hardcoding adjustment factors, reference a separate cell containing the multiplier.

=PRODUCT(B1:B4,D1)

Multiplying range B1:B4 (totaling 120) by the rate of 1.1 stored in cell D1 returns 132.

Because PRODUCT ignores blank cells and text strings in range references, it ensures clean calculations without returning value errors when optional parameters are omitted.

• Omitted and blank cells in ranges are skipped automatically.
• A single zero value in any factor collapses the entire calculation to zero.
• Use SUMPRODUCT when you need row-by-row matrix multiplication followed by an addition.

Conclusion Recap

PRODUCT is the core multiplicative function in Excel, serving as the multiplication counterpart to SUM. It is best used when combining multiple ratios, interest adjustments, or range-based multipliers into a single consolidated figure.

Across these exercises, the pattern remains straightforward: multiply an entire range, combine discrete cells, or scale a series with dynamic multipliers.

• Summary: PRODUCT multiplies all numbers and ranges supplied as arguments.
• Syntax: =PRODUCT(number1, [number2], ...) supports ranges and individual cells.
• Key behavior: Skips text and empty cells in ranges; zero values reduce the full result to zero.
• Best practice: Reference factor cells dynamically instead of hardcoding multipliers into formulas.