Baseball system help W or L

[Marcusandkylie]

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.

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

 

[richh]

N Column =IF($K9 > $L9, "", "W")
O Column =IF($K9 > $L9, "W", "")

 

[antman2988]

I'm not entirely sure what you're trying to do. Are you trying to determine whether the team will win based on their chances of winning as indicated in Columns K and L? Are you changing their win or loss status manually based on the scores in P and Q?

In the N column, you can just enter this formula.

=IF($K1>$L1,"W","")

In the O column, you can just enter this formula.

=IF($K1>$L1,"","L")

 

[Marcusandkylie]

So close but the formula needs the know the score of the game as well in column P and Q, row 9 Philly beat New York 8 -7

 

[Marcusandkylie]

my bad I forgot to mention columns P and Q

 

[antman2988]

my bad I forgot to mention columns P and Q

What is the win or loss based on? Is it based on P and Q?

 

[Marcusandkylie]

What is the win or loss based on? Is it based on P and Q?

Correct it’s based on P and Q

 

[antman2988]

I'm still trying to figure out the logic here because I assumed that if A. SCORE was greater than H. SCORE, a "W" would appear in Column N, but that doesn't seem to be the case so I'm still not entirely sure how the logic is supposed to work.

 

[Marcusandkylie]

For example, if I placed a $1,000 wager on New York because the number in Column K is greater than column L, I would go to bed crying because Philly won 8-7.
If I placed $1,000 on all the games on 2021-06-12. Based on the scores (columns P and Q) my overall W/L record would be 11-5 because placing bets on teams on whichever number is greater in column K or L.

I feel like the logic should be a LARGE function, or could be an IF with K, L, P and Q in the function bar.

=LARGE(range,1) // 1st largest
=LARGE(range,2) // 2nd largest
=LARGE(range,3) // 3rd largest

 

[antman2988]

Oh, OK. Just to be sure, for every game, you are going to choose the team with highest probability of winning, and if they don't win, you lose money. These formulas should work for you.

In Column N, enter this formula.

=IF(AND(MATCH(LARGE(K9:L9,1),K9:L9,0)=1,MATCH(LARGE(P9:Q9,1),P9:Q9,0)=1),"W",IF(AND(MATCH(LARGE(K9:L9,1),K9:L9,0)=2,MATCH(LARGE(P9:Q9,1),P9:Q9,0)=2),"W",""))

In Column O, enter this formula.

=IF(N9="","L","")

Let me know if this works for you.

Cheers!

Antman