| Spreadsheets : Formulae
| 
|
|
A formula carries out a
calculation using numbers that have
been typed into the spreadsheet. The answer appears in the cell you type
the formula into. In most spreadsheets formulas always start with a special symbol such as
the equals sign. Some simple example formulae are :
| Formula
| Explanation
| Formula
| Explanation
|
| =A1+B7 | Add up numbers in A1 and B7. | =A2/C8 | Divide number in A2 by C8. |
| =B2-C2 | Subtract number in C2 from B2. | =A1*B1 | Multiply numbers in A1 and B1. |
| =A1+B7-C2 | Add number in A1 to B7 then subtract
number in C2. | =(A1+A2)/B7 | Add together number in A1 and A2. Then
divide by number in B7. |
When you change any numbers the results of the formulas that use the numbers will be
recalculated.
GCSE ICT Companion 04 - (C) P Meakin 2004