What is PRODUCT function in Excel?
PRODUCT function is one of the Math and Trig functions in Microsoft Excel that 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 of PRODUCT function
PRODUCT(number1, [number2], …)
The PRODUCT function syntax has the following arguments:
- number1: 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 of PRODUCT function
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
| 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 |