Somehow the original files were lost (or stolen and deleted) so I've had to start from scratch. I do handicapping for various sports and the math to figure out the scores isn't that hard, it's just long. The most complicated formula in the whole process is actually the one in cell I7 that produces either a "1" or a blank space. A "1" tells me that this game has a favorable line and that people should consider betting on it. There are six possible results of a game:

1: Home team favored and covering the spread

2: Home team favored and not covering the spread

3: Home team favored and the underdog outright winning

4: Away team favored and covering

5: Away team favored and not covering

6: Away team favored and the underdog outright winning

The old formulas worked fine, but maybe I didn't check compatibility with this version of excel? While trying to rewrite the formula I used the ABS function to eliminate two of the OR statements. Each statement by itself works but when I add another AND statement for the OR Logical2 or Logical3 statement, THAT's when it fails.

The values in B1:B4 are upper and lower limits I use. B1 and B2 are for when a team is favored and I predict they will win, but either cover or not cover. The Ldog and Udog numbers are for when the underdog is predicted to win.

**Unknown 64 bit**

A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|

1 | Lowe | 7 | |||||||

2 | Upper | 21 | |||||||

3 | Ldog | 16 | |||||||

4 | Udog | 23 | |||||||

5 | |||||||||

6 | Vegas | Predicted | Actual | ||||||

7 | =IF(E7=MAX(E7,E8), E7-E8,"") | 10.00 | Charlotte | 14 | =IF(G7=MAX(G7,G8), G7-G8,"") | =IF(OR(AND(ABS(B8+D8)>$B$1,ABS(B8+D8)<$B$2),AND(ABS(B7+D7)>$B$1,ABS(B7+D7)<$B$2),AND(ABS(B8-D7)>$B$3,ABS(B8-D7)<$B$4),AND(ABS(B7-D8)>$B$3,ABS(B7-D8)<$B$4)),1,"") | |||

8 | -39.5 | -38.5 | =IF(E8=MAX(E7,E8), E8-E7,"") | 60.00 | Louisville | 70 | =IF(G8=MAX(G7,G8), G8-G7,"") |

Sheet: Sheet1 |