Spreadsheet: 127592d1320421563-excel-2007-if-and-statement-assignment
Sheet: TASK 1

Tariff | Charge/month (£) | Free mins | Free texts | Call cost per min (pence) | Cost per text (pence) |  | How many in each tarrif
A | 0 | 0 | 0 | 0.2 | 0.1
B | 20 | 120 | 120 | 0.2 | 0.1
C | 40 | 300 | unlimited | 0.2 | 0
Customer No. | No. of months with Company | Tariff | Call Mins. | No. of texts | Call charges A | Call charges B | Call charges C | Text charges A | Text charges B | Text charges C |  |  |  | total revenue | average revenue | average call mins | average texts
1 | 30 | B | 73 | 65 |  |  |  |  |  |  |  |  | [NAME] A
2 | 28 | B | 99 | 104 |  |  |  |  |  |  |  |  | [NAME] B
3 | 27 | A | 35 | 3 |  |  |  |  |  |  |  |  | [NAME] C
4 | 25 | B | 83 | 86 |  |  |  |  |  |  |  |  | Company
5 | 22 | B | 61 | 71
6 | 22 | B | 83 | 62
7 | 21 | C | 242 | 254
8 | 20 | C | 238 | 212
9 | 19 | B | 98 | 76
10 | 18 | A | 19 | 0
11 | 18 | B | 69 | 75
12 | 17 | A | 30 | 0
13 | 17 | B | 75 | 112
14 | 17 | B | 91 | 101
15 | 17 | B | 45 | 93
16 | 17 | B | 103 | 128
17 | 16 | B | 64 | 85
18 | 16 | B | 81 | 106
19 | 15 | B | 103 | 71
20 | 14 | B | 127 | 99
21 | 14 | C | 241 | 318
22 | 13 | B | 101 | 80
23 | 13 | A | 75 | 5
24 | 13 | B | 415 | 95
25 | 13 | A | 0 | 0
26 | 12 | A | 45 | 43
27 | 12 | B | 29 | 122
28 | 12 | A | 8 | 7
29 | 12 | B | 123 | 100
30 | 11 | B | 105 | 66
31 | 11 | B | 72 | 88
32 | 10 | B | 128 | 85
33 | 10 | C | 159 | 354
34 | 10 | B | 87 | 83
35 | 10 | C | 234 | 280
36 | 10 | A | 53 | 0
37 | 10 | C | 240 | 325
38 | 10 | B | 1 | 82
39 | 10 | B | 168 | 96
40 | 9 | A | 18 | 0
41 | 9 | B | 43 | 84
42 | 9 | B | 152 | 110
43 | 9 | B | 4 | 85
44 | 9 | B | 12 | 109
45 | 9 | B | 70 | 86
46 | 8 | C | 131 | 237
47 | 8 | B | 142 | 89
48 | 8 | C | 297 | 398
49 | 8 | B | 110 | 110
50 | 8 | B | 5 | 124
51 | 8 | B | 108 | 90
52 | 8 | B | 155 | 108
53 | 8 | A | 4 | 0
54 | 7 | A | 177 | 155
55 | 7 | A | 53 | 2
56 | 7 | B | 82 | 121
57 | 7 | C | 193 | 363
58 | 7 | B | 126 | 104
59 | 7 | C | 283 | 290
60 | 7 | B | 28 | 87
61 | 7 | B | 2 | 121
62 | 7 | A | 44 | 37
63 | 6 | A | 16 | 5
64 | 6 | C | 281 | 386
65 | 6 | B | 120 | 122
66 | 6 | B | 125 | 99
67 | 6 | B | 138 | 118
68 | 6 | B | 91 | 69
69 | 6 | C | 269 | 399
70 | 6 | C | 230 | 202
71 | 6 | A | 10 | 5
72 | 6 | B | 128 | 74
73 | 5 | C | 321 | 341
74 | 5 | C | 275 | 285
75 | 5 | B | 152 | 63
76 | 5 | B | 92 | 122
77 | 5 | A | 42 | 21
78 | 5 | B | 135 | 111
79 | 5 | B | 100 | 111
80 | 5 | C | 280 | 294
81 | 5 | B | 100 | 81
82 | 5 | B | 10 | 94
83 | 5 | A | 19 | 15
84 | 4 | B | 33 | 120
85 | 4 | A | 43 | 9
86 | 4 | A | 30 | 0
87 | 4 | C | 228 | 303
88 | 4 | A | 30 | 7
89 | 4 | A | 9 | 0
90 | 4 | B | 91 | 78
91 | 4 | A | 101 | 0
92 | 3 | B | 112 | 127
93 | 3 | B | 88 | 113
94 | 3 | A | 30 | 13
95 | 3 | A | 33 | 0
96 | 3 | B | 30 | 109
97 | 3 | B | 62 | 104
98 | 3 | B | 36 | 138
99 | 3 | C | 152 | 246
100 | 3 | B | 97 | 138
101 | 2 | B | 91 | 94
102 | 2 | B | 89 | 88
103 | 2 | A | 35 | 26
104 | 2 | A | 23 | 0
105 | 2 | B | 29 | 132
106 | 2 | B | 80 | 126
107 | 2 | B | 65 | 132
108 | 2 | A | 125 | 119
109 | 2 | B | 110 | 74
110 | 1 | A | 85 | 5
111 | 1 | C | 210 | 365
112 | 1 | B | 97 | 137
113 | 1 | B | 97 | 117
114 | 1 | A | 73 | 0
115 | 1 | B | 92 | 126
116 | 1 | B | 77 | 114
117 | 1 | B | 84 | 118
118 | 1 | C | 141 | 237
119 | 1 | A | 0 | 0
120 | 1 | B | 21 | 67