PRODUCT
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.