|
|
One of the primary differences between a table you create in a word processing document to segment data and a spreadsheet is the ability to evaluate data that is entered into cells with formulas. These can include the typical mathematical formulas (add, subtract, multiple, divide) to comparisons (greater than, less than) to more complex statistical and engineering concepts. You can use formulas with text, too, for things like finding a character, splitting the text in a cell, forcing the cell uppercase or lowercase, etc.To add formulas to your spreadsheets, follow these steps:- Double-click an empty cell.
- Click the Formulas button on the toolbar.
- Select a formula from the list that appears.
 - Click the More link to see additional formulas.
The formula is inserted into the cell you selected in step 1 and you can begin to enter symbols and attributes to see the formula computation.If you're using Google Chrome, Internet Explorer or Safari, you may have noticed that cells referenced by formulas get highlighted when you edit the cell with the formula in it.
|
| |
|
|
 |
|
|
