Required products: Tool Factory Spreadsheet
Formulas are a key part to any spreadsheet project. You can have them add, subtract, multiple, or divide different cells together. With them, many math functions become instantly easy.
There are two different types of formulas: pre-written and self-designed.
Example of Using a Formula to Calculate an Average (See the example Long Jump Distances example in the Resource Bank)
Step 1 - Click in the cell that you wish to apply the formula to.
Step 2 - Click the Formula button to open up the Formula panel.
Step 3 - Click the black triangle next to the green check mark to open the formula drop down menu.
Step 4 - Select 'Average (range)' from the drop down menu.
Step 5 - The words Average (range) will now appear in the formula box.
Step 6 - Hold, click, and drag the mouse over the cells which you wish to be included in the calculation. They will replace the word Range in the formula box.
Step 7 - Click the green check on the formula panel to activate the panel.
Entering Formulae Directly Into a Cell
Step 1 - Click in the cell you wish to apply the formula to and then type in the formula (example a1+a2).
Step 2 - Press enter on your keyboard or click another cell.
Step 3 - The formula will be hidden except when the cell is clicked on.
Now you know how to work through the fascinating world of formulas. There are many different options to choose from that provide endless possibilities for formula creating.
Print Instructions on Enter a Formula into a Spreadsheet (DOC)
Print Instructions on Enter a Formula into a Spreadsheet (PDF)
Mac users: To download, ctrl-click on the worksheet and choose "save link to disk"
Click images to enlarge|