Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The PRODUCT function is like a multi-tasking calculator that quickly multiplies a series of numbers together. It's a handy tool used in various applications to compute the total product of multiple numbers.
Syntax
PRODUCT(number1, [number2], ...)
The PRODUCT function syntax has the following arguments:
- number1 Required. The first number or range that you want to multiply.
- number2, ... Optional. Additional numbers or ranges that you want to multiply, up to a maximum of 255 arguments.
Example
| Formula | Description | Result |
| =PRODUCT(1, 120) | Multiplies the numbers 1 and 120. | 120 |
| =PRODUCT(3, 2, 4) | Multiplies the numbers 3, 2 and 4. | 24 |
| =PRODUCT(1, 2, 3, 4, 5, 6) | Multiplies the numbers 1 to 6. | 720 |
Errors
For a full list of formula errors, please read Formula errors.