Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 22

Thread: MS Excel 2007 Lecture # 22

1. MS Excel 2007 Lecture # 22

"The Excel 2007 PRODUCT Function Guide - Example Demonstration"

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.
• 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.
• 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•