Marcusandkylie
New Member
- Joined
- May 4, 2019
- Messages
- 12
Hello,
Need help with this Baseball System, I need excel to automatically enter the W or L result based on the highest number in columns K or L, for example, Systems says New York (6.67) should beat Philadelphia (3.60) but New York lost and I manually entered L. I have faith someone here can crack this formula.
Need help with this Baseball System, I need excel to automatically enter the W or L result based on the highest number in columns K or L, for example, Systems says New York (6.67) should beat Philadelphia (3.60) but New York lost and I manually entered L. I have faith someone here can crack this formula.
| MLB TRIAL.xlsx | |||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | |||
| 1 | CORRECT RECORD | REVERESED RECORD | |||||||||||||||||||||||||||||||||
| 2 | LEFT SIDE W/L | 64 | 33 | 66.0 | 33 | 64 | 34.0 | ||||||||||||||||||||||||||||
| 3 | RIGHT SIDE W/L | 42 | 55 | 43.3 | 55 | 42 | 56.7 | ||||||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||||||||||||
| 5 | OVER/UNDER | 52 | 43 | 4 | 54.7 | ||||||||||||||||||||||||||||||
| 6 | HOME BOYS | 68 | 31 | 68.7 | |||||||||||||||||||||||||||||||
| 7 | |||||||||||||||||||||||||||||||||||
| 8 | DATE | VISITOR | HOME | TIME (ET) | MONEYLINE | MONEYLINE | O/U | SYSTEM A - VISITOR | SYSTEM A - HOME | A. SCORE | H. SCORE | COMBINED RUNS | GAME WINNER | GAME WINNER | SYSTEM B - VISITOR | SYSTEM B - HOME | |||||||||||||||||||
| 9 | 2021-06-12 | SAT | A | New York Y | N | Philadelphia | 4:05 PM | -124 | 103 | 9 | 6.67 | 3.60 | 10.27 | L | 7 | 8 | 15 | O | W | 15.33 | 8.40 | 23.733 | L | D | -124 | -$ 620 | -$ 1,240 | ||||||||
| 10 | 2021-06-12 | SAT | A | Kansas City | A | Oakland | 4:07 PM | 155 | -190 | 9 | 3.00 | 3.56 | 6.56 | W | 2 | 11 | 13 | O | W | 16.00 | 3.44 | 19.444 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
| 11 | 2021-06-12 | SAT | A | Los Angeles A | N | Arizona | 4:10 PM | -121 | 105 | 9 | 5.40 | 5.00 | 10.40 | W | 8 | 7 | 15 | O | L | 19.60 | 22.00 | 41.6 | L | D | -100 | -$ 500 | -$ 1,000 | ||||||||
| 12 | 2021-06-12 | SAT | N | Atlanta | N | Miami | 4:10 PM | -185 | 155 | 7.5 | 3.00 | 2.50 | 5.50 | L | 2 | 4 | 6 | U | W | 16.00 | 10.50 | 26.5 | L | D | -185 | -$ 925 | -$ 1,850 | ||||||||
| 13 | 2021-06-12 | SAT | A | Baltimore | A | Tampa Bay | 4:10 PM | 190 | -255 | 7.5 | 0.67 | 4.50 | 5.17 | W | 4 | 5 | 9 | O | W | 6.33 | 13.50 | 19.833 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 14 | 2021-06-12 | SAT | A | Chicago W | A | Detroit | 4:10 PM | -205 | 170 | 9 | 4.00 | 2.80 | 6.80 | W | 15 | 2 | 17 | O | L | 9.00 | 10.20 | 19.2 | L | D | -100 | -$ 500 | -$ 1,000 | ||||||||
| 15 | 2021-06-12 | SAT | N | Colorado | N | Cincinnati | 4:10 PM | 145 | -170 | 9 | 3.89 | 13.75 | 17.64 | W | 3 | 10 | 13 | O | W | 4.11 | -0.75 | 3.3611 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
| 16 | 2021-06-12 | SAT | N | Pittsburgh | N | Milwaukee | 4:10 PM | 265 | -325 | 7.5 | 2.67 | 5.25 | 7.92 | W | 4 | 7 | 11 | O | W | 4.33 | 7.75 | 12.083 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 17 | 2021-06-12 | SAT | N | San Diego | N | New York M | 4:10 PM | -140 | 115 | 7 | 1.11 | 2.63 | 3.74 | W | 1 | 4 | 5 | U | W | 4.89 | 9.38 | 14.264 | W | D | 115 | $ 575 | $ 1,150 | ||||||||
| 18 | 2021-06-12 | SAT | A | Seattle | A | Cleveland | 4:10 PM | 100 | -120 | 8.5 | 0.00 | 12.25 | 12.25 | W | 4 | 5 | 9 | O | W | 7.00 | 10.75 | 17.75 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 19 | 2021-06-12 | SAT | A | Toronto | A | Boston | 4:10 PM | -105 | -115 | 10 | 8.89 | 5.33 | 14.22 | W | 7 | 2 | 9 | U | L | 17.11 | 5.67 | 22.778 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 20 | 2021-06-12 | SAT | A | Houston | A | Minnesota | 7:15 PM | -130 | 110 | 9.5 | 0.67 | 2.67 | 3.33 | W | 2 | 5 | 7 | U | W | 13.33 | 4.33 | 17.667 | L | D | -130 | -$ 650 | -$ 1,300 | ||||||||
| 21 | 2021-06-12 | SAT | N | San Francisco | N | Washington | 2:05 PM | -174 | 145 | 6 | 0.44 | 0.00 | 0.44 | L | 0 | 2 | 2 | U | W | 3.56 | 4.00 | 7.5556 | W | D | 145 | $ 725 | $ 1,450 | ||||||||
| 22 | 2021-06-12 | SAT | N | San Francisco | N | Washington | 7:15 PM | -120 | 100 | 7 | 0.00 | 1.33 | 1.33 | L | 2 | 1 | 3 | U | L | 8.00 | 4.67 | 12.667 | W | D | 100 | $ 500 | $ 1,000 | ||||||||
| 23 | 2021-06-12 | SAT | N | St. Louis | N | Chicago C | 7:15 PM | 160 | -190 | 8.5 | 5.00 | 10.00 | 15.00 | W | 2 | 7 | 9 | O | W | 8.00 | -3.00 | 5 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
| 24 | 2021-06-12 | SAT | A | Texas | N | Los Angeles D | 10:10 PM | 232 | -281 | 7.5 | 0.44 | 24.00 | 24.44 | L | 12 | 1 | 13 | O | L | 18.56 | -9.00 | 9.5556 | W | F | 232 | $ 1,160 | $ 2,320 | ||||||||
| 25 | 2021-06-13 | SUN | A | New York Y | N | Philadelphia | 1:05 PM | 110 | -132 | 8.5 | 7.00 | 11.20 | 18.20 | W | 0 | 7 | 7 | U | W | 11.00 | 12.80 | 23.8 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 26 | 2021-06-13 | SUN | N | San Francisco | N | Washington | 1:05 PM | -108 | -112 | 8.5 | 0.75 | 0.50 | 1.25 | L | 0 | 5 | 5 | U | W | 23.25 | 8.50 | 31.75 | L | F | -108 | -$ 540 | -$ 1,080 | ||||||||
| 27 | 2021-06-13 | SUN | N | Atlanta | N | Miami | 1:10 PM | 108 | -129 | 7.5 | 1.56 | 4.00 | 5.56 | L | 6 | 4 | 10 | O | L | 9.44 | 6.00 | 15.444 | W | F | 108 | $ 540 | $ 1,080 | ||||||||
| 28 | 2021-06-13 | SUN | A | Baltimore | A | Tampa Bay | 1:10 PM | 156 | -187 | 8 | 2.67 | 5.63 | 8.29 | W | 1 | 7 | 8 | P | W | 5.33 | 17.38 | 22.708 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 29 | 2021-06-13 | SUN | A | Chicago W | A | Detroit | 1:10 PM | -227 | 189 | 9 | 21.67 | 1.11 | 22.78 | W | 4 | 1 | 5 | U | L | 5.33 | 13.89 | 19.222 | L | D | -100 | -$ 500 | -$ 1,000 | ||||||||
| 30 | 2021-06-13 | SUN | N | Colorado | N | Cincinnati | 1:10 PM | 136 | -164 | 9.5 | 2.33 | 17.50 | 19.83 | W | 2 | 6 | 8 | U | W | 9.67 | 3.50 | 13.167 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
| 31 | 2021-06-13 | SUN | N | San Diego | N | New York M | 1:10 PM | -132 | 110 | 8 | 0.67 | 2.50 | 3.17 | L | 7 | 3 | 10 | O | L | 9.33 | 4.50 | 13.833 | W | D | 100 | $ 500 | $ 1,000 | ||||||||
| 32 | 2021-06-13 | SUN | A | Seattle | A | Cleveland | 1:10 PM | 202 | -243 | 7.5 | 3.20 | 4.00 | 7.20 | L | 6 | 2 | 8 | O | L | 22.80 | 12.00 | 34.8 | W | F | 202 | $ 1,010 | $ 2,020 | ||||||||
| 33 | 2021-06-13 | SUN | A | Toronto | A | Boston | 1:10 PM | -133 | 111 | 10 | 7.78 | 1.11 | 8.89 | W | 18 | 4 | 22 | O | L | 3.22 | 12.89 | 16.111 | L | D | -100 | -$ 500 | -$ 1,000 | ||||||||
| 34 | 2021-06-13 | SUN | A | Houston | A | Minnesota | 2:10 PM | -180 | 145 | 9.5 | 1.11 | 5.00 | 6.11 | L | 14 | 3 | 17 | O | L | 5.89 | 10.00 | 15.889 | L | D | -100 | -$ 500 | -$ 1,000 | ||||||||
| 35 | 2021-06-13 | SUN | N | Pittsburgh | N | Milwaukee | 2:10 PM | 156 | -187 | 8.5 | 4.44 | 7.00 | 11.44 | W | 2 | 5 | 7 | U | W | 18.56 | 5.00 | 23.556 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
| 36 | 2021-06-13 | SUN | A | Kansas City | A | Oakland | 4:07 PM | 173 | -208 | 8.5 | 1.11 | 19.25 | 20.36 | W | 3 | 6 | 9 | O | W | 14.89 | -2.25 | 12.639 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
| 37 | 2021-06-13 | SUN | A | Los Angeles A | N | Arizona | 4:10 PM | -137 | 114 | 9.5 | 10.67 | 7.78 | 18.44 | W | 10 | 3 | 13 | O | L | 8.33 | -0.78 | 7.5556 | W | D | 100 | $ 500 | $ 1,000 | ||||||||
| 38 | 2021-06-13 | SUN | A | Texas | N | Los Angeles D | 4:10 PM | 195 | -235 | 8 | 22.67 | 0.67 | 23.33 | L | 3 | 5 | 8 | P | W | -7.67 | 11.33 | 3.6667 | W | F | 100 | $ 500 | $ 1,000 | ||||||||
| 39 | 2021-06-13 | SUN | N | St. Louis | N | Chicago C | 7:00 PM | 109 | -131 | 9.5 | 1.11 | 4.38 | 5.49 | W | 0 | 2 | 2 | U | W | 13.89 | 8.63 | 22.514 | L | F | -100 | -$ 500 | -$ 1,000 | ||||||||
Sheet1 | |||||||||||||||||||||||||||||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| Y8 | Cell Value | between 8.01 and 3.888 | text | NO |
| X8 | Cell Value | between 8.01 and 3.888 | text | NO |
| L8 | Cell Value | between 8.01 and 3.888 | text | NO |
| Y7,K8:K21 | Cell Value | between 8.01 and 3.888 | text | NO |
| L22 | Other Type | Icon set | NO | |
| Z22 | Other Type | Icon set | NO | |
| X22 | Other Type | Icon set | NO | |
| I1:I4,I7 | Other Type | Icon set | NO | |
| Z1,Z4,Z7 | Other Type | Icon set | NO | |
| K1:K4,K7 | Other Type | Icon set | NO | |
| Z8,AP1:AP7 | Other Type | Icon set | NO | |
| I6 | Other Type | Icon set | NO | |
| K6 | Other Type | Icon set | NO | |
| Y22 | Cell Value | between #REF! and #REF! | text | NO |
| Y22 | Other Type | Color scale | NO | |
| K22 | Cell Value | between 8.01 and 3.888 | text | NO |
| Q6 | Cell Value | between 4 and 5 | text | NO |
| Q1:Q4,Q7 | Cell Value | between 4 and 5 | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Cleveland" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Washington" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Colorado" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Arizona" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Texas" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Boston" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Minnesota" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Philadelphia" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "New York M" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "San Francisco" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Los Angeles D" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "San Diego" | text | NO |
| F1:F3,F6:F92 | Cell Value | contains "Miami" | text | NO |
| Y23:Y92,AO1:AO7,Y9:Y21 | Cell Value | between #REF! and #REF! | text | NO |
| Y23:Y92,AO1:AO7,Y9:Y21 | Other Type | Color scale | NO | |
| AF3 | Cell Value | between 8.01 and 3.888 | text | NO |
| AE2 | Cell Value | between 8.01 and 3.888 | text | NO |
| AF2 | Cell Value | between 8.01 and 3.888 | text | NO |
| AD3 | Cell Value | between 8.01 and 3.888 | text | NO |
| Y3 | Cell Value | between 8.01 and 3.888 | text | NO |
| Z3 | Cell Value | between 8.01 and 3.888 | text | NO |
| X2 | Cell Value | between 8.01 and 3.888 | text | NO |
| Z2 | Cell Value | between 8.01 and 3.888 | text | NO |
| Y1,Y4,K23:K92 | Cell Value | between 8.01 and 3.888 | text | NO |
| X23:X92,X9:X21 | Other Type | Icon set | NO | |
| Z23:Z92,Z9:Z21 | Other Type | Icon set | NO | |
| L23:L92,L9:L21 | Other Type | Icon set | NO | |
