This function multiplies all the arguments and returns the product.
PRODUCT(value1,value2,...)
PRODUCT(array)
PRODUCT(array1,array2,...)
Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.
If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.
Accepts numeric data for all arguments. Returns numeric data.
PRODUCT(B3,B7,12)
PRODUCT(C4,B2,B4,C5)
PRODUCT(A1:A9)
PRODUCT(R1C2,2,10)
PRODUCT(A1:A8,B1:B8,C2:C18)
PRODUCT(1,2,3,5,7,11,13) gives the result 30030
This function is available in product version 1.0 or later.
FACT | QUOTIENT | SUMPRODUCT | Statistical Functions