Excel PRODUCT Function
PRODUCT multiplies numeric values from the numbers, cells, or ranges you provide.
Use it for factor chains, quantity calculations, rate adjustments, compounding multipliers, and formulas where several numbers need to be multiplied together.
PRODUCT syntax & arguments
Syntax
=PRODUCT(number1, [number2], ...)
-
1
number1
RequiredThe first number, cell reference, or range to multiply.
-
2
number2
Optional RepeatableAdditional numbers, cell references, or ranges to multiply by the running product.
Example
=PRODUCT(B2:D2)
Multiply the numeric values in B2:D2 together.
PRODUCT caveats
-
Zeros zero out the result
Any multiplied value of
0makes the final PRODUCT result0. -
Text in referenced cells is ignored
Numbers stored as text do not multiply when they are inside referenced cells. Use VALUE when text numbers need to become numeric first.
-
Errors stop the calculation
If a referenced cell contains an error, PRODUCT returns an error instead of a partial product.
Need row-by-row multiplication plus a total? Use SUMPRODUCT when matching positions should be multiplied and then added.
Intro PRODUCT practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced PRODUCT practice problems
Use PRODUCT alongside other Excel functions in realistic, less-prescriptive challenges.
