| #DIV/0! | You are trying to divide by zero |
| ###### | The column may not be wide enough to show all the figures |
| #VALUE! | You may have text where there should be a number |
| #NAME? | Excel does not recognise the text in a formula |
| #NULL! | There is nothing where something is expected |
| #NUM! | The number values are not valid |
| #REF! | The cell reference is not valid |
| #N/A | A value is not available/data is missing |
| |
A |
B |
C |
D |
| 1 |
Party
Budget - at home |
|
|
|
| 2 |
|
|
|
|
| 3 |
Item |
Number |
Cost(£) |
Total
Cost(£) |
| 4 |
|
|
|
|
| 5 |
Catering |
20 |
3 |
=B5*C5 |
| 6 |
Magician |
1 |
60 |
=B6*C6 |
| 7 |
Party
bag |
20 |
1 |
=B7*C7 |
| 8 |
Balloons |
1 |
10 |
=B8*C8 |
| 9 |
Cake |
1 |
15 |
=B9*C9 |
| 10 |
|
|
Total |
=D5+D6+D7+D8+D9 |
| 11 |
|
|
Per
child |
=D10/20 |
|
Quiz Night |
|
|
|
|
|
|
|
|
|
|
| |
Round |
|
|
|
|
|||||
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
|
|
|
| |
History |
TV |
M |
GK |
Ge |
Film |
Joker round |
Total points |
Joker points |
Grand Total |
| |
|
|
|
|
|
|
|
|
|
|
| Team 1 |
18 |
10 |
15 |
10 |
19 |
16 |
1 |
=SUM(B6:G6) |
=B6 |
=I6+J6 |
| Team 2 |
15 |
8 |
13 |
8 |
17 |
14 |
2 |
=SUM(B7:G7) |
=C7 |
=I7+J7 |
| Team 3 |
8 |
10 |
9 |
12 |
9 |
11 |
2 |
=SUM(B8:G8) |
=C8 |
=I8+J8 |
| Team 4 |
17 |
15 |
14 |
17 |
19 |
18 |
4 |
=SUM(B9:G9) |
=E9 |
=I9+J9 |
| Team 5 |
12 |
15 |
10 |
13 |
10 |
18 |
4 |
=SUM(B10:G10) |
=E10 |
=I10+J10 |
| Team 6 |
7 |
9 |
9 |
9 |
10 |
11 |
4 |
=SUM(B11:G11) |
=E11 |
=I11+J11 |
| Team 7 |
12 |
14 |
13 |
15 |
13 |
16 |
6 |
=SUM(B12:G12) |
=G12 |
=I12+J12 |
| Team 8 |
19 |
17 |
14 |
18 |
13 |
15 |
1 |
=SUM(B13:G13) |
=B13 |
=I13+J13 |
| Team 9 |
12 |
13 |
16 |
17 |
12 |
19 |
6 |
=SUM(B14:G14) |
=G14 |
=I14+J14 |
| Team 10 |
10 |
11 |
15 |
12 |
11 |
12 |
4 |
=SUM(B15:G15) |
=E15 |
=I15+J15 |
| |
|
|
|
|
|
|
|
|
|
|
| Average score |
=AVERAGE(B6:B15) |
|
|
|
|
=AVERAGE(G6:G15) |
|
Champions |
=MAX(K6:K15) |
|
| |
|
|
|
|
|
|
|
Wooden spoon |
=MIN(K6:K15) |
|
| Anglebar Tools - Commission Tracker |
|
|
|
||||
| 30
May 2003 |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| Commission
Rate A |
5% |
|
|
|
|
|
|
| Commission
Rate B |
10% |
|
|
|
|
|
|
| Commission
Rate C |
15% |
Items sold |
|||||
| |
|
Tools |
Commission (Rate A) |
Accessories |
Commission (Rate B) |
Consumables |
Commission (Rate C) |
| Salesman
1 |
|
1300 |
=C8*$B$4 |
582 |
=E8*$B$5 |
317 |
=G8*$B$6 |
| Salesman
2 |
|
1224 |
=C9*$B$4 |
280 |
=E9*$B$5 |
289 |
=G9*$B$6 |
| Salesman
3 |
|
1026 |
=C10*$B$4 |
332 |
=E10*$B$5 |
297 |
=G10*$B$6 |
| Salesman
4 |
|
1670 |
=C11*$B$4 |
620 |
=E11*$B$5 |
124 |
=G11*$B$6 |
| Salesman
5 |
|
1488 |
=C12*$B$4 |
719 |
=E12*$B$5 |
188 |
=G12*$B$6 |
| |
|
|
|
|
|
|
|
| Total
Commission |
=SUM(D8:D12)+SUM(F8:F12)+SUM(H8:H12) |
|
|
|
|||
| |
|
|
|
||||
| The 2003 Ashfield Athletic Meeting
|
|
|||||
| |
|
|
|
|
|
|
| Event |
Surname |
Forename |
Club |
Personal Best |
Result |
|
| |
|
|
|
|
|
|
| 100mtrs |
Baptist |
Kyle |
Hilcrest |
10.99 |
11.01 |
=IF(F5<E5,"PB","
") |
| |
Williams |
Odette |
V&V |
11.1 |
11 |
=IF(F6<E6,"PB","
") |
| |
Raman |
Sherif |
Fielden |
10.8 |
10.99 |
=IF(F7<E7,"PB","
") |
| |
Hills |
Saleem |
|
10.75 |
10.95 |
=IF(F8<E8,"PB","
") |
| |
Nield |
Conrad |
Raylor |
11.2 |
10.95 |
=IF(F9<E9,"PB","
") |
| |
Njerba |
James |
Grenfer |
10.94 |
10.87 |
=IF(F10<E10,"PB","
") |
| |
Coya |
Paul |
C&C |
10.8 |
10.8 |
=IF(F11<E11,"PB","
") |
| |
Carr |
Lee |
Drayton |
10.54 |
10.55 |
=IF(F12<E12,"PB","
") |
| |
Seth |
Marcus |
Merses |
10.79 |
10.53 |
=IF(F13<E13,"PB","
") |
| Home |
|
||||||||||||||||||||||
| Module 1 | |||||||||||||||||||||||
| Module 2 | |||||||||||||||||||||||
| Module 3 | |||||||||||||||||||||||
| Module 4 | |||||||||||||||||||||||
| Module 5 | |||||||||||||||||||||||
| Module 6 | |||||||||||||||||||||||
| Module 7 | |||||||||||||||||||||||
| Module E | |||||||||||||||||||||||
| Links | |||||||||||||||||||||||