Spreadsheet: 552318d1513456061-if-statement-problem-for-rating-sports-teams-copy
Sheet: Sheet1

 |  |  |  |  |  | Home
 |  | lookup2 |  |  |  | 3.68419
 |  | 1 | 1 Arizona Cardinals | RATING
 |  | 2 | 2 Atlanta Falcons
 |  | 3 | 3 Baltimore Ravens
 |  | 4 | 4 Buffalo Bills
 |  | 5 | 5 Carolina Panthers
 |  | 6 | 6 Chicago Bears
 |  | 7 | 7 Cincinnati Bengals
 |  | 8 | 8 Cleveland Browns
 |  | 9 | 9 Dallas Cowboys
 |  | 10 | 10 Denver Broncos
 |  | 11 | 11 Detroit Lions
 |  | 12 | 12 Green Bay Packers
 |  | 13 | 13 Houston Texans
 |  | 14 | 14 Indianapolis Colts
 |  | 15 | 15 [NAME]
 |  | 16 | 16 Kansas City Chiefs
 |  | 17 | 17 Miami Dolphins
 |  | 18 | 18 Minnesota Vikings
 |  | 19 | 19 New England Patriots
 |  | 20 | 20 New Orleans Saints
 |  | 21 | 21 New York Giants
 |  | 22 | 22 New York Jets
 |  | 23 | 23 Oakland Raiders
 |  | 24 | 24 Philadelphia Eagles
 |  | 25 | 25 Pittsburgh Steelers
 |  | 26 | 26 St. [NAME]
 |  | 27 | 27 San Diego Chargers
 |  | 28 | 28 San Francisco 49ers
 |  | 29 | 29 [NAME]
 |  | 30 | 30 Tampa Bay Buccaneers
 |  | 31 | 31 Tennessee Titans
 |  | 32 | 32 Washington Redskins |  |  |  | IF(A39="c",0.5*$G$2,IF(A39="n",0,$G$2))+VLOOKUP(C39,lookup2,3)-VLOOKUP(D39,lookup2,3)
 |  |  |  | AVERAGE
 | game# | home | away | homesc | awaysc | margin | predict | error | sq err
C | 1 | 19 | 23 | 30 | 20
C | 2 | 32 | 6 | 9 | 7
 | 3 | 8 | 7 | 13 | 27
 | 4 | 17 | 10 | 34 | 10
 | 5 | 4 | 13 | 22 | 7
 | 6 | 5 | 20 | 20 | 23
 | 7 | 16 | 22 | 27 | 7
 | 8 | 15 | 29 | 26 | 14
 | 9 | 18 | 30 | 13 | 24
 | 10 | 25 | 31 | 34 | 7
 | 11 | 21 | 1 | 42 | 19
 | 12 | 27 | 9 | 24 | 28
 | 13 | 11 | 12 | 17 | 3
 | 14 | 28 | 26 | 28 | 25
 | 15 | 3 | 14 | 7 | 24
 | 16 | 2 | 24 | 14 | 10
 | 17 | 31 | 3 | 25 | 10
 | 18 | 30 | 4 | 19 | 3
 | 19 | 6 | 11 | 38 | 6
 | 20 | 14 | 15 | 10 | 3
 | 21 | 7 | 18 | 37 | 8
 | 22 | 5 | 19 | 27 | 17
 | 23 | 13 | 25 | 7 | 27
 | 24 | 24 | 28 | 42 | 3
 | 25 | 29 | 2 | 21 | 18
 | 26 | 1 | 26 | 12 | 17
 | 27 | 12 | 8 | 24 | 26
 | 28 | 22 | 17 | 17 | 7
 | 29 | 10 | 27 | 20 | 17
 | 30 | 23 | 16 | 17 | 23
 | 31 | 21 | 20 | 27 | 10
 | 32 | 9 | 32 | 13 | 14
 | 33 | 4 | 2 | 16 | 24
 | 34 | 17 | 5 | 27 | 24
 | 35 | 6 | 7 | 7 | 24
 | 36 | 14 | 8 | 13 | 6
 | 37 | 22 | 15 | 20 | 26
 | 38 | 18 | 20 | 33 | 16
 | 39 | 24 | 23 | 23 | 20
 | 40 | 12 | 30 | 16 | 17
 | 41 | 26 | 31 | 31 | 27
 | 42 | 29 | 1 | 37 | 12
 | 43 | 28 | 9 | 31 | 34
 | 44 | 25 | 19 | 20 | 23
 | 45 | 27 | 21 | 45 | 23
 | 46 | 10 | 16 | 30 | 10
C | 47 | 20 | 4 | 19 | 7
 | 48 | 15 | 10 | 7 | 20
 | 49 | 30 | 11 | 17 | 13
 | 50 | 7 | 13 | 16 | 10
 | 51 | 31 | 14 | 10 | 31
 | 52 | 16 | 24 | 31 | 37
 | 53 | 19 | 27 | 17 | 41
 | 54 | 32 | 29 | 20 | 17
 | 55 | 21 | 26 | 44 | 24
 | 56 | 3 | 22 | 13 | 3
 | 57 | 23 | 9 | 19 | 13
 | 58 | 2 | 18 | 30 | 10
n | 59 | 1 | 28 | 31 | 14
 | 60 | 5 | 12 | 32 | 29
 | 61 | 11 | 3 | 35 | 17
 | 62 | 8 | 6 | 20 | 10
 | 63 | 4 | 17 | 20 | 14
 | 64 | 2 | 19 | 28 | 31
 | 65 | 12 | 20 | 52 | 3
 | 66 | 26 | 29 | 31 | 37
 | 67 | 22 | 30 | 14 | 12
 | 68 | 13 | 31 | 20 | 34
 | 69 | 28 | 14 | 3 | 28
 | 70 | 1 | 5 | 20 | 24
 | 71 | 9 | 24 | 33 | 10
 | 72 | 10 | 32 | 21 | 19
 | 73 | 15 | 7 | 23 | 20
 | 74 | 27 | 25 | 22 | 24
C | 75 | 20 | 2 | 31 | 34
 | 76 | 11 | 5 | 20 | 21
 | 77 | 31 | 7 | 23 | 31
 | 78 | 3 | 8 | 16 | 3
 | 79 | 25 | 15 | 17 | 23
 | 80 | 30 | 17 | 27 | 13
 | 81 | 6 | 18 | 28 | 3
 | 82 | 9 | 21 | 16 | 13
 | 83 | 16 | 32 | 28 | 21
 | 84 | 10 | 19 | 28 | 20
 | 85 | 4 | 22 | 27 | 17
 | 86 | 23 | 27 | 14 | 27
 | 87 | 29 | 13 | 42 | 10
 | 88 | 14 | 26 | 45 | 28
 | 89 | 17 | 16 | 20 | 30
 | 90 | 8 | 11 | 10 | 13
 | 91 | 18 | 12 | 23 | 20
 | 92 | 13 | 14 | 20 | 38
 | 93 | 26 | 20 | 28 | 17
 | 94 | 7 | 25 | 13 | 27
 | 95 | 24 | 27 | 20 | 17
 | 96 | 32 | 28 | 52 | 17
 | 97 | 29 | 9 | 13 | 10
 | 98 | 6 | 3 | 10 | 6
 | 99 | 23 | 4 | 38 | 17
 | 100 | 21 | 10 | 24 | 23
 | 101 | 1 | 31 | 20 | 10
 | 102 | 2 | 22 | 27 | 14
 | 103 | 9 | 1 | 34 | 13
 | 104 | 11 | 6 | 13 | 19
 | 105 | 13 | 8 | 19 | 16
 | 106 | 7 | 12 | 21 | 14
 | 107 | 26 | 15 | 24 | 21
C | 108 | 20 | 17 | 6 | 21
 | 109 | 5 | 18 | 38 | 13
 | 110 | 31 | 23 | 25 | 34
 | 111 | 21 | 32 | 36 | 0
 | 112 | 27 | 16 | 28 | 20
 | 113 | 10 | 24 | 49 | 21
 | 114 | 28 | 30 | 15 | 10
 | 115 | 19 | 4 | 21 | 16
 | 116 | 25 | 3 | 20 | 19
 | 117 | 17 | 2 | 10 | 17
 | 118 | 30 | 5 | 14 | 34
C | 119 | 20 | 6 | 17 | 20
 | 120 | 3 | 7 | 9 | 21
 | 121 | 18 | 11 | 27 | 14
 | 122 | 15 | 13 | 21 | 14
 | 123 | 16 | 23 | 27 | 23
 | 124 | 22 | 27 | 26 | 31
 | 125 | 8 | 31 | 20 | 14
 | 126 | 28 | 21 | 6 | 24
 | 127 | 1 | 29 | 19 | 33
 | 128 | 12 | 25 | 10 | 20
 | 129 | 32 | 24 | 17 | 10
 | 130 | 19 | 14 | 21 | 40
 | 131 | 11 | 1 | 29 | 21
 | 132 | 15 | 3 | 30 | 3
 | 133 | 14 | 13 | 31 | 17
 | 134 | 4 | 16 | 14 | 3
 | 135 | 21 | 18 | 21 | 24
 | 136 | 17 | 19 | 16 | 23
 | 137 | 6 | 28 | 17 | 9
 | 138 | 30 | 32 | 36 | 35
 | 139 | 23 | 10 | 17 | 31
 | 140 | 5 | 22 | 30 | 3
 | 141 | 2 | 12 | 25 | 33
 | 142 | 29 | 26 | 31 | 16
 | 143 | 25 | 8 | 34 | 21
 | 144 | 24 | 9 | 20 | 21
 | 145 | 26 | 1 | 28 | 38
 | 146 | 6 | 5 | 13 | 3
 | 147 | 9 | 11 | 20 | 7
 | 148 | 7 | 14 | 37 | 45
 | 149 | 31 | 15 | 28 | 31
 | 150 | 8 | 17 | 22 | 0
 | 151 | 19 | 20 | 24 | 17
 | 152 | 32 | 23 | 13 | 16
 | 153 | 21 | 24 | 27 | 17
 | 154 | 2 | 30 | 27 | 30
 | 155 | 28 | 29 | 25 | 27
 | 156 | 27 | 4 | 48 | 10
 | 157 | 10 | 22 | 27 | 0
 | 158 | 3 | 25 | 16 | 13
 | 159 | 13 | 16 | 17 | 45
 | 160 | 12 | 18 | 17 | 20
 | 161 | 11 | 2 | 7 | 27
 | 162 | 9 | 10 | 21 | 24
 | 163 | 7 | 3 | 42 | 29
 | 164 | 4 | 5 | 9 | 13
 | 165 | 30 | 6 | 10 | 13
 | 166 | 18 | 8 | 24 | 12
 | 167 | 16 | 19 | 26 | 16
 | 168 | 32 | 27 | 17 | 23
 | 169 | 31 | 28 | 33 | 22
 | 170 | 13 | 26 | 27 | 33
 | 171 | 1 | 15 | 17 | 24
 | 172 | 23 | 17 | 21 | 33
 | 173 | 24 | 12 | 19 | 14
 | 174 | 29 | 21 | 24 | 21
 | 175 | 22 | 20 | 19 | 21
 | 176 | 14 | 25 | 26 | 7
 | 177 | 5 | 2 | 24 | 6
 | 178 | 17 | 4 | 24 | 23
 | 179 | 25 | 7 | 31 | 38
 | 180 | 21 | 9 | 17 | 10
 | 181 | 6 | 12 | 19 | 7
 | 182 | 3 | 13 | 16 | 15
 | 183 | 8 | 15 | 14 | 20
 | 184 | 11 | 18 | 16 | 21
C | 185 | 20 | 30 | 3 | 10
 | 186 | 14 | 31 | 35 | 3
 | 187 | 28 | 1 | 10 | 17
 | 188 | 26 | 32 | 9 | 24
 | 189 | 16 | 10 | 31 | 27
 | 190 | 19 | 22 | 16 | 3
 | 191 | 27 | 23 | 34 | 10
 | 192 | 24 | 29 | 0 | 42
 | 193 | 25 | 6 | 21 | 9
 | 194 | 7 | 8 | 23 | 20
 | 195 | 31 | 13 | 13 | 10
 | 196 | 15 | 14 | 18 | 26
 | 197 | 4 | 19 | 7 | 35
 | 198 | 22 | 23 | 26 | 10
 | 199 | 18 | 26 | 27 | 13
 | 200 | 5 | 30 | 10 | 20
 | 201 | 24 | 21 | 23 | 26
 | 202 | 29 | 28 | 41 | 3
 | 203 | 1 | 32 | 13 | 17
 | 204 | 10 | 3 | 12 | 10
 | 205 | 9 | 16 | 31 | 28
 | 206 | 27 | 17 | 21 | 23
 | 207 | 12 | 11 | 16 | 13
 | 208 | 2 | 20 | 36 | 17
 | 209 | 19 | 30 | 28 | 0
 | 210 | 21 | 16 | 27 | 17
 | 211 | 4 | 10 | 17 | 28
 | 212 | 13 | 1 | 30 | 19
C | 213 | 20 | 5 | 10 | 27
 | 214 | 32 | 9 | 35 | 7
 | 215 | 17 | 22 | 24 | 20
 | 216 | 18 | 25 | 3 | 18
 | 217 | 14 | 27 | 17 | 26
 | 218 | 31 | 29 | 24 | 28
 | 219 | 15 | 28 | 10 | 9
 | 220 | 11 | 7 | 17 | 41
 | 221 | 23 | 8 | 7 | 9
 | 222 | 26 | 24 | 16 | 17
 | 223 | 6 | 2 | 16 | 3
 | 224 | 3 | 12 | 48 | 3
 | 225 | 30 | 2 | 27 | 24
 | 226 | 7 | 4 | 27 | 37
 | 227 | 5 | 9 | 20 | 24
C | 228 | 20 | 11 | 12 | 13
 | 229 | 13 | 15 | 20 | 38
 | 230 | 32 | 21 | 35 | 20
 | 231 | 8 | 25 | 0 | 41
 | 232 | 16 | 27 | 20 | 7
 | 233 | 26 | 28 | 20 | 24
 | 234 | 17 | 31 | 24 | 10
 | 235 | 1 | 24 | 27 | 21
 | 236 | 29 | 14 | 28 | 13
 | 237 | 10 | 23 | 22 | 3
 | 238 | 12 | 6 | 17 | 24
 | 239 | 3 | 18 | 30 | 23
 | 240 | 22 | 19 | 21 | 31
 | 241 | 27 | 10 | 7 | 23
 | 242 | 23 | 21 | 21 | 30
 | 243 | 14 | 1 | 17 | 13
 | 244 | 8 | 3 | 20 | 16
 | 245 | 22 | 4 | 30 | 26
 | 246 | 2 | 5 | 11 | 44
 | 247 | 18 | 6 | 34 | 10
 | 248 | 16 | 7 | 37 | 3
 | 249 | 25 | 11 | 35 | 21
 | 250 | 19 | 17 | 26 | 28
 | 251 | 30 | 20 | 27 | 13
 | 252 | 28 | 13 | 20 | 17
 | 253 | 15 | 31 | 40 | 13
 | 254 | 12 | 29 | 23 | 17
 | 255 | 24 | 32 | 20 | 31
 | 256 | 9 | 26 | 10 | 20
 | 257P | 30 | 32 | 10 | 17
 | 258P | 19 | 15 | 28 | 3
 | 259P | 21 | 5 | 0 | 23
 | 260P | 7 | 25 | 17 | 31
 | 261P | 29 | 32 | 20 | 10
 | 262P | 10 | 19 | 27 | 13
 | 263P | 14 | 25 | 18 | 21
 | 264P | 6 | 5 | 21 | 29
 | 265P | 10 | 25 | 17 | 34
 | 266P | 29 | 5 | 34 | 14