Multiplies the given expressions. If an expression evaluates to a range of cells all the values in the range are multiplied. Text in ranges are ignored. If an error condition is encountered in a range of cells, the product function errors as well.
Syntax
PRODUCT(expression,{expression},...)
Arguments
expression - numbers or cell references to multiply.
Example
PRODUCT( 3.14, -2, 2 ) = -12.56 PRODUCT( A2..B5, 200 )