The PRODUCT function provides a quick way to multiple numbers in a Excel. The advantage of using this function becomes apparent if you have several numbers to multiply together. It is easier then building a long formula.
The syntax for the PRODUCT function is:
=PRODUCT( Number1, Number2, ... Number255 )
Up to 255 numbers can be entered into the function.
Example Using Excel's PRODUCT Feature:
For help with this example, see the image above.
- Enter the following data:
C1 - 235
C2 - 546
- Click on cell C3 - the location where the results will be displayed.
- Click on the Formulas tab of the ribbon menu.
- Choose Math & Trig from the ribbon to open the function drop down list.
- Click on PRODUCT in the list to bring up the function's dialog box.
- In the dialog box, click on the Number1 line.
- Drag select cells C1 and C2 in the spreadsheet to add these cell references to the Number1 line.
- Click OK.
- The answer 128,310 should appear in cell C3.
- When you click on cell C3 the complete function = PRODUCT (C1 : C2) appears in the formula bar above the worksheet.
Related Tutorials
