Entering Functions


You can enter a function into a formula either by typing the name of the function or by pasting the function into the formula from a list of functions displayed on the Formulas tab. (You don't have to be on the Formulas tab to enter functions manually, however.) To use the Formulas tab to enter formulas, follow these steps:

1.

Click the Formulas tab, as shown in Figure 34.

Figure 34. The Google Spreadsheets Formulas tab.


2.

Move the cursor into the cell you want to hold the results of the function.

3.

Click the More link at the top right of the page.

4.

When the Insert a Function dialog box appears, as shown in Figure 35, click the function you want to use.

Figure 35. Choosing a function from the Insert a Function dialog box.


5.

Click the Close link to close the Insert a Function dialog box.

6.

The function is now pasted into the selected cell. As you can see in Figure 36, the placeholder text args is used for the argument part of the function. Use your keyboard or mouse to replace the args placeholder with the desired argument (typically a range reference) for this function.

Figure 36. The selected function pasted into a 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