Using the PRODUCT Function


The final function listed separately in the Google Spreadsheets workspace is the PRODUCT function. This function calculates the product of the specified valuesthat is, it multiplies all the selected cells or values together. For example, if you have three cells with the values 2, 3, and 4 (respectively), the PRODUCT functions multiplies 2 times 3 times 4 and returns the value 24.

To multiply a range of numbers with the PRODUCT function, follow these steps:

1.

Select the cell where you want the result to appear.

2.

Click the Product link; this inserts =Product( into the selected cell.

3.

Use your keyboard or mouse to select the range of cells you want multiplied together.

4.

Use your keyboard to enter the ) character to close the function argument.

5.

Press the Enter key.

Google Spreadsheets now multiplies the values in all the selected cells and places the product into the current cell.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net