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
Where the number arguments are up to 255 numeric values
Example of PRODUCT Function in Excel
- 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
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.