Topic 21: Example Using the Excel 2007 PRODUCT Function

[seema]

The Excel 2007 PRODUCT function provides a quick way to multiple numbers and returns the product (result).

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)

Number1, Number2, … is numbers that enter into the Excel spreadsheet. Up to 255 numbers can be entered into the function.
To use the PRODUCT function (an example)

Enter the following data into cells C1 to C3: Click on cell C5 - the location where the results will be displayed. Click on the Excel 2007 Formulas tab.

Similar Threads:

• Topic 19: Do You Really Know the Excel 2007 Function?
• Topic 17: Formatting the Excel 2007 Table As You Needs!
• Topic 16: How to Insert a Table in Excel 2007?
• Topic 10: Getting Help with Excel 2007 Help Feature
• Topic 3: Is There Something New About Excel 2007 Ribbon?

[seema]

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.

[seema]

From the Function Arguments dialog box displayed, enter C1 for Number1 and C2 for Number2. Click OK. The result will display on cell C5 that is 80 in this case. The results you will get: =Product(C1, C2) would return 80. =Product(C1, C2, C3) would return 720. =Product(C1, C2, C3, -2) would return -1440.