|
A |
B |
C |
D |
E |
|
|
1 |
How much do |
12 |
Oranges cost @ |
£0.24 |
Each? |
|
2 |
=B1*D1 |
|
A |
B |
C |
D |
E |
|
|
1 |
What's 2 ? |
2
|
Plus |
2 |
? |
|
2 |
=B1+D1 |
|
A |
B |
C |
D |
E |
|
|
1 |
How much is one
cigarette if |
£3.48 |
Is the cost of
|
20 |
? |
|
2 |
=B1/D1 |
|
A |
B |
C |
D |
E |
|
|
1 |
How much did I
spend if from |
£11 |
I received |
£7.52
|
change? |
|
2 |
=B1-D1 |
|
A |
B |
C |
D |
E |
|
|
1 |
What's the total
of these numbers |
33.3 |
3.33 |
333 |
? |
|
2 |
=sum(B1:D1) |
 |
Always start a formula with = |
|
It is easier to use the + - * and / signs on the number pad of the keyboard (if included). Otherwise you'll need shift 8and shift = to get * and +. |
|
The S button can help to total rows or columns. Select the box where the total is to go. Click the S button. Check the area selected for totalling (select the right area with the mouse if the computer gets it wrong). Press Enter. |
|
If you want to add, say, two numbers together and then multiply the answer by another number you'll need to put brackets round the addition, like this =(D3+E3)*2 |
