Anita has added all the information to her spreadsheet, but now she needs to calculate the amount of stock she has, and the cost of that stock. She can do this using a number of different spreadsheet formulas that make mathematical equations seem easy.
Remember to always begin with the = sign when entering a formula.
Table of formulas
| Formula |
Maths equivalent |
Process |
|---|
| =B3+B4 |
2.50 + 3.99 |
Addition |
| =B3-B4 |
2.50 - 3.99 |
Subtraction |
| =B3*C3 |
2.50 x 35 |
Multiplication |
| =B3/C3 |
2.50 ÷ 35 |
Division |
| =SUM(B2:B5) |
2.99 + 2.50 + 3.99 + 1.99 |
Adds the contents of the cell range from B2 to B5 |
| =B3>B4 |
2.50 > 3.99 |
Are the cell contents of B3 greater than B4? TRUE or FALSE |
| =B4<B3 |
3.99 < 2.50 |
Are the cell contents of B4 less than B3? TRUE or FALSE |
| =IF(B2=7,"OK","Not OK") |
Ìý |
Checks the condition of a cell, gives appropriate results if True or False. |
| =AVERAGE(B2:B4) |
(2.99 + 2.50 + 3.99) ÷ 3 |
Calculates the average of the contents of the cell range B2 to B4 |
Choosing your formula
The 'Stock', 'Cost' and 'Totals' for Anita's spreadsheet can be calculated using spreadsheet formulae.
| Ìý |
A |
B |
C |
D |
E |
F |
|---|
| 1 |
Supplier |
Price £ |
No. of Videos |
No. of DVDs |
Stock |
Cost |
|---|
| 2 |
Paramount |
2.99 |
20 |
30 |
Ìý |
Ìý |
|---|
| 3 |
Universal |
2.50 |
35 |
20 |
Ìý |
Ìý |
|---|
| 4 |
Buena Vista |
3.99 |
45 |
25 |
Ìý |
Ìý |
|---|
| 5 |
New Line |
1.99 |
50 |
35 |
Ìý |
Ìý |
|---|
| 6 |
Total |
Ìý |
Ìý |
Ìý |
Ìý |
Ìý |
|---|
To calculate the Stock for Paramount, you need to know:
- No. of Videos + No of DVDs = Stock (number of items in store)
This simple addition equation uses information from cell C2 and D2 to work out the stock total for Paramount in cell E2.
|
