Sign in

Docs Help



General Information: Adding formulas

Print

To add formulas to your spreadsheets, follow these instructions:

  1. Double-click an empty cell.
  2. Click the Formulas button on the toolbar.
  3. Select a formula from the list that appears.

    formula tab

  4. Click the More link to see additional formulas.

    more option

    The formula is inserted into the cell you selected in step 1.

  5. Enter symbols and attributes to see the formula computation.

To use the GoogleFinance formula, follow these instructions:

  1. Double-click an empty cell.
  2. Click the Formulas tab.
  3. Click Google.
  4. Click GoogleFinance.
  5. The formula is added to the cell.
  6. Enter a symbol and an attribute. For example, "goog" and "price" (a). This gives you the current Google stock price (b).
Looking for information on available functions? Check this list.
Was this information helpful?

Docs for teachers and businesses

Docs for business

Docs for teachers

Adding Docs to a Website

Sounds great! Tell me more.

Tell us how we're doing: Please answer a few questions about your experience to help us improve our Help Center.