Multiplies all the numbers given as arguments and returns the product.
Syntax
PRODUCT(number1,number2,...)
Number1, number2,... are 1 to 30 numbers that you want to multiply.
Remarks
-
Arguments that are numbers, logical values, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers cause errors.
-
If an argument is a column reference, only numbers are counted. Empty arguments, logical values, text, or error values are ignored.
Examples
Col1 |
Col2 |
Col3 |
Formula |
Description (Result) |
---|---|---|---|---|
5 |
15 |
30 |
=PRODUCT([Col1], [Col2], [Col3]) |
Multiplies the numbers (2250) |
5 |
15 |
30 |
=PRODUCT([Col1], [Col2], [Col3],2) |
Multiplies the numbers and 2 (4500) |