Spreadsheet: 28420d1222693748-problem-with-if-statment-banter-cup-2
Sheet: Sheet1

 |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts | H | A | Pts
1 | 2008-09-27 00:00:00 | Arsenal | 1 | v | 2 | Hull City | 4 | 0 | 0 | 1 | 2 | 3
2 | 2008-09-27 00:00:00 | [NAME] | 2 | v | 1 | Sunderland | 1 | 0 | 1 | 4 | 1 | 1
3 | 2008-09-27 00:00:00 | Everton | 0 | v | 2 | Liverpool | 1 | 1 | 0 | 2 | 0 | 0
4 | 2008-09-27 00:00:00 | Fulham | 1 | v | 2 | West Ham | 2 | 1 | 0
5 | 2008-09-27 00:00:00 | Portsmouth | 2 | v | 0 | Spurs | 1 | 1 | 0
6 | 2008-09-27 00:00:00 | [NAME] | 2 | v | 1 | Man City | 0 | 2 | 0
 |  |  |  |  |  |  |  |  | 1 |  |  | 4 |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
7 | 2008-10-04 00:00:00 | [NAME] |  | v |  | Man United
8 | 2008-10-04 00:00:00 | Chelsea |  | v |  | [NAME]
9 | 2008-10-04 00:00:00 | Everton |  | v |  | Newcastle
10 | 2008-10-04 00:00:00 | Man City |  | v |  | Liverpool
11 | 2008-10-04 00:00:00 | Spurs |  | v |  | Hull City
12 | 2008-10-04 00:00:00 | West Ham |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
13 | 2008-10-18 00:00:00 | Arsenal |  | v |  | Everton
14 | 2008-10-18 00:00:00 | Liverpool |  | v |  | [NAME]
15 | 2008-10-18 00:00:00 | Man United |  | v |  | West Brom
16 | 2008-10-18 00:00:00 | Midd'bro |  | v |  | Chelsea
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
17 | 2008-10-25 00:00:00 | [NAME] |  | v |  | Midd'bro
18 | 2008-10-25 00:00:00 | Chelsea |  | v |  | Liverpool
19 | 2008-10-25 00:00:00 | Sunderland |  | v |  | Newcastle
20 | 2008-10-25 00:00:00 | [NAME] |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
21 | 2008-10-29 00:00:00 | Arsenal |  | v |  | Spurs
22 | 2008-10-29 00:00:00 | [NAME] |  | v |  | [NAME]
23 | 2008-10-29 00:00:00 | Fulham |  | v |  | [NAME]
24 | 2008-10-29 00:00:00 | Newcastle |  | v |  | West Brom
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
25 | 2008-11-01 00:00:00 | [NAME] |  | v |  | Man City
26 | 2008-11-01 00:00:00 | Midd'bro |  | v |  | West Ham
27 | 2008-11-01 00:00:00 | Portsmouth |  | v |  | [NAME]
28 | 2008-11-01 00:00:00 | West Brom |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
29 | 2008-11-08 00:00:00 | Arsenal |  | v |  | Man United
30 | 2008-11-08 00:00:00 | Hull City |  | v |  | [NAME]
31 | 2008-11-08 00:00:00 | Sunderland |  | v |  | Portsm'th
32 | 2008-11-08 00:00:00 | [NAME] |  | v |  | Stoke City
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
33 | 2008-11-15 00:00:00 | [NAME] |  | v |  | Sunderland
34 | 2008-11-15 00:00:00 | Everton |  | v |  | Midd'bro
35 | 2008-11-15 00:00:00 | Fulham |  | v |  | Spurs
36 | 2008-11-15 00:00:00 | Hull City |  | v |  | Man City
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
37 | 2008-11-22 00:00:00 | [NAME] |  | v |  | Man United
38 | 2008-11-22 00:00:00 | Man City |  | v |  | Arsenal
39 | 2008-11-22 00:00:00 | Stoke City |  | v |  | West Brom
40 | 2008-11-22 00:00:00 | Spurs |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
41 | 2008-11-29 00:00:00 | Chelsea |  | v |  | Arsenal
42 | 2008-11-29 00:00:00 | Man City |  | v |  | Man United
43 | 2008-11-29 00:00:00 | Midd'bro |  | v |  | Newcastle
44 | 2008-11-29 00:00:00 | Sunderland |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
45 | 2008-12-06 00:00:00 | Everton |  | v |  | [NAME]
46 | 2008-12-06 00:00:00 | Hull City |  | v |  | Midd'bro
47 | 2008-12-06 00:00:00 | West Brom |  | v |  | Portsm'th
48 | 2008-12-06 00:00:00 | West Ham |  | v |  | Spurs
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
49 | 2008-12-13 00:00:00 | Chelsea |  | v |  | West Ham
50 | 2008-12-13 00:00:00 | Midd'bro |  | v |  | Arsenal
51 | 2008-12-13 00:00:00 | Spurs |  | v |  | Man United
52 | 2008-12-13 00:00:00 | [NAME] |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
53 | 2008-12-20 00:00:00 | [NAME] |  | v |  | Portsm'th
54 | 2008-12-20 00:00:00 | Hull City |  | v |  | Sunderland
55 | 2008-12-20 00:00:00 | West Brom |  | v |  | Man City
56 | 2008-12-20 00:00:00 | West Ham |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
57 | 2008-12-26 00:00:00 | [NAME] |  | v |  | Arsenal
58 | 2008-12-26 00:00:00 | Midd'bro |  | v |  | Everton
59 | 2008-12-26 00:00:00 | Portsmouth |  | v |  | West Ham
60 | 2008-12-26 00:00:00 | Spurs |  | v |  | Fulham
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
61 | 2008-12-28 00:00:00 | [NAME] |  | v |  | Man City
62 | 2008-12-28 00:00:00 | [NAME] |  | v |  | [NAME]
63 | 2008-12-28 00:00:00 | Fulham |  | v |  | Chelsea
64 | 2008-12-28 00:00:00 | Newcastle |  | v |  | Liverpool
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
65 | 2009-01-10 00:00:00 | Arsenal |  | v |  | [NAME]
66 | 2009-01-10 00:00:00 | [NAME] |  | v |  | West Brom
67 | 2009-01-10 00:00:00 | Everton |  | v |  | Hull City
68 | 2009-01-10 00:00:00 | Fulham |  | v |  | [NAME]
69 | 2009-01-10 00:00:00 | Man United |  | v |  | Chelsea
70 | 2009-01-10 00:00:00 | Midd'bro |  | v |  | Sunderland
71 | 2009-01-10 00:00:00 | Newcastle |  |  |  | West Ham
72 | 2009-01-10 00:00:00 | Portsmouth |  |  |  | Man City
73 | 2009-01-10 00:00:00 | Stoke City |  | v |  | Liverpool
74 | 2009-01-10 00:00:00 | [NAME] |  | v |  | Spurs
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
75 | 2009-01-17 00:00:00 | [NAME] |  | v |  | Man United
76 | 2009-01-17 00:00:00 | Liverpool |  | v |  | Everton
77 | 2009-01-17 00:00:00 | Man City |  | v |  | [NAME]
78 | 2009-01-17 00:00:00 | Spurs |  | v |  | Portsm'th
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
79 | 2009-01-31 00:00:00 | Arsenal |  | v |  | West Ham
80 | 2009-01-31 00:00:00 | [NAME] |  | v |  | Spurs
81 | 2009-01-31 00:00:00 | Liverpool |  | v |  | Chelsea
82 | 2009-01-31 00:00:00 | Newcastle |  | v |  | Sunderland
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
83 | 2009-02-07 00:00:00 | Everton |  | v |  | [NAME]
84 | 2009-02-07 00:00:00 | Man City |  | v |  | Midd'bro
85 | 2009-02-07 00:00:00 | Sunderland |  | v |  | Stoke City
86 | 2009-02-07 00:00:00 | Spurs |  | v |  | Arsenal
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
87 | 2009-02-21 00:00:00 | Fulham |  | v |  | West Brom
88 | 2009-02-21 00:00:00 | Liverpool |  | v |  | Man City
89 | 2009-02-21 00:00:00 | Newcastle |  | v |  | Everton
90 | 2009-02-21 00:00:00 | Stoke City |  | v |  | Portsm'th
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
91 | 2009-02-28 00:00:00 | Arsenal |  | v |  | Fulham
92 | 2009-02-28 00:00:00 | [NAME] |  | v |  | Newcastle
93 | 2009-02-28 00:00:00 | Hull City |  | v |  | [NAME]
94 | 2009-02-28 00:00:00 | Sunderland |  | v |  | Spurs
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
95 | 2009-03-04 00:00:00 | [NAME] |  | v |  | Everton
96 | 2009-03-04 00:00:00 | Fulham |  | v |  | Hull City
97 | 2009-03-04 00:00:00 | Man City |  | v |  | [NAME]
98 | 2009-03-04 00:00:00 | Newcastle |  | v |  | Man United
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
99 | 2008-03-14 00:00:00 | [NAME] |  | v |  | Fulham
100 | 2008-03-14 00:00:00 | Hull City |  | v |  | Newcastle
101 | 2008-03-14 00:00:00 | Man United |  | v |  | Liverpool
102 | 2008-03-14 00:00:00 | Midd'bro |  | v |  | Portsm'th
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
103 | 2008-03-21 00:00:00 | Fulham |  | v |  | Man United
104 | 2008-03-21 00:00:00 | Newcastle |  | v |  | Arsenal
105 | 2008-03-21 00:00:00 | Stoke City |  | v |  | Midd'bro
106 | 2008-03-21 00:00:00 | Spurs |  | v |  | Chelsea
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
107 | 2009-04-04 00:00:00 | Arsenal |  | v |  | Man City
108 | 2009-04-04 00:00:00 | Man United |  | v |  | [NAME]
109 | 2009-04-04 00:00:00 | Newcastle |  | v |  | Chelsea
110 | 2009-04-04 00:00:00 | West Brom |  | v |  | Stoke City
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
111 | 2009-04-11 00:00:00 | [NAME] |  | v |  | Everton
112 | 2009-04-11 00:00:00 | Liverpool |  | v |  | [NAME]
113 | 2009-04-11 00:00:00 | Stoke City |  | v |  | Newcastle
114 | 2009-04-11 00:00:00 | Spurs |  | v |  | West Ham
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
115 | 2009-04-18 00:00:00 | Liverpool |  | v |  | Arsenal
116 | 2009-04-18 00:00:00 | Stoke City |  | v |  | [NAME]
117 | 2009-04-18 00:00:00 | Sunderland |  | v |  | Hull City
118 | 2009-04-18 00:00:00 | [NAME] |  | v |  | Man United
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
119 | 2009-04-25 00:00:00 | Everton |  | v |  | Man City
120 | 2009-04-25 00:00:00 | Man United |  | v |  | Spurs
121 | 2009-04-25 00:00:00 | Newcastle |  | v |  | Portsm'th
122 | 2009-04-25 00:00:00 | West Ham |  | v |  | Chelsea
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
123 | 2009-05-02 00:00:00 | Chelsea |  | v |  | Fulham
124 | 2009-05-02 00:00:00 | Man City |  | v |  | [NAME]
125 | 2009-05-02 00:00:00 | Portsmouth |  | v |  | Arsenal
126 | 2009-05-02 00:00:00 | [NAME] |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
127 | 2009-05-09 00:00:00 | Arsenal |  | v |  | Chelsea
128 | 2009-05-09 00:00:00 | [NAME] |  | v |  | Sunderland
129 | 2009-05-09 00:00:00 | Newcastle |  | v |  | Midd'bro
130 | 2009-05-09 00:00:00 | West Brom |  | v |  | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
131 | 2009-05-16 00:00:00 | Man United |  | v |  | Arsenal
132 | 2009-05-16 00:00:00 | Midd'bro |  | v |  | [NAME]
133 | 2009-05-16 00:00:00 | Stoke City |  | v |  | [NAME]
134 | 2009-05-16 00:00:00 | Spurs |  | v |  | Man City
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
135 | 2009-05-24 00:00:00 | Arsenal |  | v |  | Stoke City
136 | 2009-05-24 00:00:00 | [NAME] |  | v |  | Newcastle
137 | 2009-05-24 00:00:00 | [NAME] |  | v |  | West Brom
138 | 2009-05-24 00:00:00 | Fulham |  | v |  | Everton
139 | 2009-05-24 00:00:00 | Hull City |  | v |  | Man United
140 | 2009-05-24 00:00:00 | Liverpool |  | v |  | Spurs
141 | 2009-05-24 00:00:00 | Man City |  | v |  | [NAME]
142 | 2009-05-24 00:00:00 | Sunderland |  | v |  | Chelsea
143 | 2009-05-24 00:00:00 | West Ham |  | v |  | Midd'bro
144 | 2009-05-24 00:00:00 | [NAME] |  | v |  | Portsm'th
 |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 |  | POINTS TOTALS ----
 | TOTAL GOALS PREDICTED ----