PRODUCT Function in Excel – Get the Multiplication of values in Excel

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

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.