MS Excel: PRODUCT Function (WS)
In Microsoft Excel, the PRODUCT function multiplies the numbers and returns the product.
The syntax for the PRODUCT function is:
PRODUCT( number1, number2, ... number_n )
number1, number2, ... number_n are the numbers to multiply together. There can be up to 30 numbers entered.
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the PRODUCT function in a worksheet:
Based on the Excel spreadsheet above, the PRODUCT function would return the following:
|=PRODUCT(A1, A2)||would return 12|
|=PRODUCT(A1, A2, A3)||would return 54|
|=PRODUCT(A1, A2, A3, A4)||would return -366.12|
|=PRODUCT(A1, A2, A3, A4, -2)||would return 732.24|