PRODUCT()
Syntax. PRODUCT(number1,number2,...)
Definition. This function multiplies the arguments and returns the product.
Arguments
number1 (required) and number2 (optional) The minimum number of values is 1, and the maximum is 255 (30 in Excel 2003 and earlier versions) that you want to multiply. (One number is required, but for a multiplication a second value makes sense.) Instead of using separate numbers, it is also possible to build a product for a range of cells—for example, A1:A5.
Background. The product is the result of multiplication, and the multiplied values are the factors:
a1 • a2 • a3 • a4•...•an = b
In mathematics, analogous to the sum symbol Σ is the symbol Π for product. Π stands for the product of multiple factors.
Example. Multiplication ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
