PRODUCT function
Summary
Multiplies its arguments
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.
Note: If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical values, and text in the array or reference are ignored.
• 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.
Note: If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical values, and text in the array or reference are ignored.
Example
=PRODUCT(A2:A4)
=PRODUCT(A2:A4, 2)
=A2*A3*A4
=PRODUCT(A2:A4, 2)
=A2*A3*A4