The PRODUCT function returns the product of all values.
This function can be useful for quickly performing calculations involving multiplication.
Syntax
PRODUCT(value1, [value2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
value1 |
First number or range for calculating the product |
Number, range of cells, cell references or ranges with numbers |
[value2, ...] |
(optional) Additional multipliers |
Similar to the first argument |
Examples of use
Multiplying several numbers
If you want to multiply the numbers 2, 3, and 4:
=PRODUCT(2, 3, 4)
Result: 24, since 2 × 3 × 4 = 24.
Multiplying values from a range
If cells A1:A3 contain the values 2, 3, and 4, and you want to find their product:
=PRODUCT(A1:A3)
Result: 24.
Combining ranges and individual numbers
If cells B1:B3 contain the values 1, 2, and 3, and you want to multiply them by 4:
=PRODUCT(B1:B3, 4)
Result: 24 (1 × 2 × 3 × 4).
Notes
–The PRODUCT function ignores empty cells and text values that cannot be converted to numbers.
–If there is a cell containing zero in the range, the result of the product will be zero.