Using the Excel PRODUCT Function


The Excel PRODUCT function takes all of the numbers provided in the argument and multiplies them, returning a product. The same operation can also be performed using the mathematical multiplication operator (*); for example, =A1 * A2 or =5 * 8.


=PRODUCT (number1, [number2], ...)

Syntax Breakdown

The number1 argument is required and is the first number or range of numbers that you would like to multiply.

The number2 and any subsequent number arguments are optional. This argument can be a single number or a range of numbers. The PRODUCT function can handle up to 255 arguments.

Usage Notes

The PRODUCT function is used to multiple many cells or range of cells together. The mathematical multiplication operator (*) performs the same function.

For example, =PRODUCT(A1,A2) will provide the same result as =A1 * A2.

If the number1 or other number argument includes an array or reference of cells only numbers are multiplied. Empty cells, logical values, and text in the array are ignored.

Excel PRODUCT Example