"The Excel 2007 PRODUCT Function Guide - Example Demonstration"


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:
  • Excel 2007 data

  • 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.
  • Excel 2007 Product function

  • 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.
  • Excel 2007 Product function arguments

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


Related Topics:

This tutorial is about Excel 2007 Product Function, visit the following links for more Excel 2007 functions:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
How to Use the Cell Function in Microsoft Excel 2007?
Guide to Use the NOW Function Correctly in Excel 2007
Demonstration of Using the Date and Time Functions with Excel 2007
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Using the Excel 2007 Count Function - Example Demonstration
Guide to Use the Excel 2007 Radian Function Correctly



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 Product function info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.