This article describes the formula syntax and usage of the PRODUCT function in Microsoft Excel.
Description
The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2.
The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.
Syntax
PRODUCT(number1, [number2], ...)
The PRODUCT function syntax has the following arguments:
-
number1 Required. The first number or range that you want to multiply.
-
number2, ... Optional. Additional numbers or ranges that you want to multiply, up to a maximum of 255 arguments.
Note: If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical values, and text in the array or reference are ignored.
Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Data | ||
|---|---|---|
|
5 |
||
|
15 |
||
|
30 |
||
|
Formula |
Description |
Result |
|
=PRODUCT(A2:A4) |
Multiplies the numbers in cells A2 through A4. |
2250 |
|
=PRODUCT(A2:A4, 2) |
Multiplies the numbers in cells A2 through A4, and then multiplies that result by 2. |
4500 |
|
=A2*A3*A4 |
Multiplies the numbers in cells A2 through A4 by using mathematical operators instead of the PRODUCT function. |
2250 |