Using Formulas

Entering a Formula Into a Cell

Click on the cell where the formula will reside. Type the equation into the cell. You can also click the fx button in the formula bar to see a list of available formulas.

image alt text

Press Enter. The formula will return the resulting value (in this case, 30). Notice that a green triangle now occupies the lower right corner of the cell. This indicates that the cell contains a formula.

image alt text

When you move the cursor over the green triangle the formula will display.

image alt text

NOTE: If you need to reference a cell in another worksheet, use our new Spreadsheets document type that offers a cross-sheet formulas option. You can learn more about flexible links and other advantages that Spreadsheets has over Workbooks in the Explore Spreadsheets article.

Using the Formula Bar

The Formula Bar appears along the top of your document when the table is active. When you select a cell, the contents of that cell are displayed in the Formula Bar text box.

image alt text

You can also enter a formula directly into the Formula Bar text box.

To enter a formula into the Formula Bar, select the cell where the formula will appear. Click on the Formula Bar text box. Enter the equation or click the fx button to see available formulas, then press Enter.

The ability to resize the formula bar is important to accommodate cells with extensive text and large source links in text. When a cell has extensive content that cannot be clearly displayed in the standard formula bar, click and drag along the lower edge of the formula bar to resize it to suit your content. If you return to working with another cell containing less content, you can double click on the lower border of the formula bar to return to the default cell size.

Using the Equal Sign and Arrow Keys

Select the cell where the formula will appear then type in the equal (=) sign. Enter in your Operator (SUM, AVERAGE, MIN, etc) and the beginning left parenthesis for example, =SUM(.

Using the arrows on your keyboard, navigate to the cell where you want the formula to begin. Hold down the Shift key on your keyboard, and continue to arrow down to the desired cell range for your formula

Press ENTER to accept the range.

Copying and Deleting Formulas

Formulas can be copied from one cell to another within the same document or between documents using Copy and Paste. Keep in mind, however, that when a copied equation references a cell, the cell reference will change relative to where the formula is pasted.

To delete a formula, select the cell and press Delete.