Game Results

[Steve 1962]

Hi

I have a table (columns A to E) which shows 8 x games, with two teams playing each other in each. I have made selections in column G and would like either WIN, LOSS or DRAW based on the selection in G, shown in column H. Suitable formula required in column H.

Thanks

Book1
	A	B	C	D	E	F	G	H
1	Game	Team 1	Score	Team 2	Score		Team Selection	Win / Loss
2	1	A	34	I	30		A	Win
3	2	B	20	J	36		J	Win
4	3	C	20	K	18		K	Loss
5	4	D	38	L	34		D	Win
6	5	E	12	M	26		M	Win
7	6	F	40	N	18		F	Win
8	7	G	26	O	22		G	Win
9	8	H	24	P	24		P	Draw
Sheet3

 

[Ezguy4u]

Steve let's get the ball rolling. Here is my solution to your problem. Sometimes the A+ students will weigh in and come up with an alternative.

Book1
	A	B	C	D	E	F	G	H
1	Game	Team 1	Score	Team 2	Score		Team Selection	Win / Loss
2	1	A	34	I	30		A	Win
3	2	B	20	J	36		J	Win
4	3	C	20	K	18		K	Loss
5	4	D	38	L	34		D	Win
6	5	E	12	M	26		M	Win
7	6	F	40	N	18		F	Win
8	7	G	26	O	22		G	Win
9	8	H	24	P	24		P	Draw
Data

Cell Formulas
Range	Formula
H2:H9	H2	=IF(B2=G2,IF(C2>E2,"Win",IF(C2=E2,"Draw","Loss")),IF(C2>E2,"Loss",IF(C2=E2,"Draw","Win")))

 

[Steve 1962]

Hey thanks Ezguy4u

Works fine thanks. Open to all suggestions.

Thanks for your help.

 

[Peter_SSs]

Open to all suggestions.

Here are two more then.
(BTW, you are a pretty good picker! )

23 07 09.xlsm
	A	B	C	D	E	F	G	H	I
1	Game	Team 1	Score	Team 2	Score		Team Selection	Win / Loss	Win / Loss
2	1	A	34	I	30		A	Win	Win
3	2	B	20	J	36		J	Win	Win
4	3	C	20	K	18		K	Loss	Loss
5	4	D	38	L	34		D	Win	Win
6	5	E	12	M	26		M	Win	Win
7	6	F	40	N	18		F	Win	Win
8	7	G	26	O	22		G	Win	Win
9	8	H	24	P	24		P	Draw	Draw
WLD

Cell Formulas
Range	Formula
H2:H9	H2	=MID("LossDrawWin",IF(B2=G2,4,-4)*SIGN(C2-E2)+5,4)
I2:I9	I2	=INDEX({"Loss","Draw","Win"},IF(B2=G2,1,-1)*SIGN(C2-E2)+2)

 

[Steve 1962]

Hey thanks Peter

Both of your's work fine as well.

My picking is like the weather. Sometimes good and sometimes bad. Obviously won't make a living out of it.

All the best and thanks again.

Steve

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.