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

PRODUCT (number1, [number2], …)

Where the number arguments are up to 255 numeric values

Example of PRODUCT Function in Excel

Formula

PRODUCT Function in Excel 1

  • 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

PRODUCT Function in Excel 2

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.

 previous-small PRODUCT Function in Excel                                                                                                               next_small PRODUCT Function in Excel