Description
Use this function to return the product of multiple values multiplied together. Supported in Chains. Can be used with CHILDREFS.
Because it can accept a range of cells as an argument, this function is useful when multiplying many cells together.
Syntax
PRODUCT(number_1, […, number_254])
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number_1 |
Yes | The initial value to be used. | A number, a cell reference, a cell range, or a formula which results in any of these. |
number_n |
No | The subsequent values to be used as multiplier(s) of the previous values. | A number, a cell reference, a cell range, or a formula which results in any of these. Up to 254 additional values can be provided. |
Examples
Sample data
| A | B | |
|---|---|---|
| 1 | 11 | 9 |
| 2 | 8 | 97 |
| 3 | 3.5 | 4.3 |
| 4 | 0 | 55.08 |
| 5 | red | eggplant |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Multiply a specific value by a referenced cell. | =PRODUCT(4, A1) |
This formula works in the following manner:
For this data set, this formula returns 44. |
| Multiply values from multiple cells and cell ranges, ignoring text. | =PRODUCT(A2, A3, B3:B5) |
This formula works in the following manner:
For this data set, this formula returns 6631.728. |
| Multiply a cell value by a range of values, handling zero. | =PRODUCT(A4, B2:B5) |
This formula works in the following manner:
For this data set, this formula returns 0. |
| Multiply the result of a calculation by a cell range. | =PRODUCT(A2+A3, B3:B4) |
This formula works in the following manner:
For this data set, this formula returns 2723.706. |
Notes
- Empty cells, logical values, and text values are ignored.
- PRODUCT can accept up to 255 items, which are entered as individual arguments separated by commas. Example:
PRODUCT(A1, A2, B3:B5). - Wildcards don't work with this function.