PRODUCT function in Excel returns the product of values supplied as multiple arguments. PRODUCT can handle up to 255 individual arguments.
Syntax of PRODUCT Function in Excel
PRODUCT (number1, [number2], …)
Where the number arguments are up to 255 numeric values
Example of PRODUCT Function in Excel
Formula
- Row number 2 finds the product of the first row
- Row number 3 finds the product of the first column
- Row number 4 finds the product of the third row
- Row number 5 finds the product of all the values across rows and columns
So the result will be
Result
Note: #VALUE! Error occurs if the supplied number argument is non-numeric.
#NUM! Error occurs if any of the supplied number arguments are less than zero.