The PRODUCT function returns the product (multiplication) of a supplied set of numerical values.
=PRODUCT(num_1,[num_2], … )
Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.
|The number arguments are a set of numbers (or arrays of numbers) that you want to find the product of
Values Counted as Numeric
Numbers and dates are always counted as numeric values by the Excel Product function. However, text representations and logical values are handled differently, depending on whether they are values stored in the cells of your spreadsheet, or they are supplied directly to the function.
|Value Within a Range of Cells||Value Supplied Directly to Function|
|Text Representations of Numbers & Dates||Ignored||Included|
|Other Text||Ignored||#VALUE! Error|
|2||3||=PRODUCT(3,6,2,8,5)||1,440||Arguments entered as individual numbers|
|3||6||=PRODUCT(A2:A6)||1,440||Multiplies the numbers in cells A2 through A6|
|4||2||=PRODUCT(A2:A6,2)||2,880||Multiplies the numbers in cells A2 through A6, then multiplies that result by 2|
|5||8||=PRODUCT(“3”,A3:A6)||#VALUE!||One of the numbers is a text string|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the supplied arguments can not be interpreted as numeric values|