Menu
EXCEL PRODUCT FUNCTION
Excel PRODUCT Function Introduction
The PRODUCT function in Excel provides the products (multiplication) of a given collection of numerical values.
Description of Excel PRODUCT Function
Syntax :
=PRODUCT( number1, [number2], … )
Parameters :
The number parameters are a collection of numbers (or arrays of numbers) on which you want to compute the product. The Excel Product function accepts up to 255 number parameters in current versions of Excel (Excel 2007 and beyond), however it only accepts up to 30 arguments in Excel 2003. Each parameter, on the other hand, can be an array of data or a group of cells, each of which would contain several values.
Step By Step Guide of PRODUCT Function
Example :
Each parameter to the Product function can be provided as a single value or cell reference, or as an array of values or cells, as seen in the example spreadsheet above.
Key Points
- #VALUE! – This error occurs when any of the arguments passed directly to the Product function cannot be read as numeric values. (Note that the function ignores values that cannot be understood as numbers in a provided range of cells – see the table below.)
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
