Page 67 - ICT_for_JHS_3_Classical

Excel because what will appear in the cell is "1+1." You must begin the equation

with an equals sign, or =1+1. This holds true for any formula—simple or
complicated—that adds, subtracts, multiplies or divides.

To create a simple formula that adds two numbers:

1. Click the cell where the formula will be defined.
2. Type the equals sign (=) to let Excel know that a formula is being
defined.
3. Type the first number to be added (128, for example).
4. Type the addition sign (+) to let Excel know that an add operation is to

be performed.
5. Type the second number to be added (345, for example).
6. Press Enter, or click the Enter button on the Formula bar to complete
the formula.

NB: Excel will not always tell you if your formula contains an error, so it's up
to you to check all of your formulas.

Creating a simple addition formula

What if a column contains many numbers, each of which regularly changes? You
don't want to write a new formula each time a number is changed. Luckily, Excel
lets you include cell references in formulas.

To create a simple formula that adds the contents of two cells:
1. Type the numbers you want to calculate in separate cells (for example,
type 128 in cell B2 and 345 in cell B3).
2. Click the cell where the answer will appear (B4, for example).
3. Type the equals sign (=) to let Excel know that a formula is being

defined.
4. Type the cell number that contains the first number to be added (B2, for
example).
5. Type the addition sign (+) to let Excel know that an add operation is to
be performed.

6. Type the cell number that contains the first number to be added (B3, for