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
  • The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default 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:


    Name:  excel-2007-data.gif
Views: 313
Size:  6.0 KB


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

    Name:  excel-product-function.jpg
Views: 190
Size:  25.7 KB


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

    Name:  excel-product-function-argument.jpg
Views: 167
Size:  34.8 KB


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



    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

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

     

Tags for this Thread

Posting Permissions

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