2 Criteria IF Statement

[markhib]

simply want to say if Home Team is A, and Home Score is greater than Away Score, use AHW (A Home Win)


Only bothered about teams A & B so 8 possible combinations.

Hope someone can help me..

Thanks

	A</SPAN>	B</SPAN>	C</SPAN>	D</SPAN>	E</SPAN>
1</SPAN>	Home Team</SPAN></SPAN>	HomeScore</SPAN>	Away Score</SPAN>	Away Team</SPAN></SPAN>	Result</SPAN>
2</SPAN>	A</SPAN></SPAN>	1</SPAN>	2</SPAN>	C</SPAN></SPAN>	AHL</SPAN>
3</SPAN>	A</SPAN></SPAN>	3</SPAN>	0</SPAN>	D</SPAN></SPAN>	AHW</SPAN>
4</SPAN>	B</SPAN></SPAN>	4</SPAN>	1</SPAN>	E</SPAN></SPAN>	BHW</SPAN>
5</SPAN>	B</SPAN></SPAN>	2</SPAN>	3</SPAN>	F</SPAN></SPAN>	BHL</SPAN>
6</SPAN>	G</SPAN></SPAN>	3</SPAN>	2</SPAN>	A</SPAN></SPAN>	AAL</SPAN>
7</SPAN>	H</SPAN></SPAN>	1</SPAN>	2</SPAN>	A</SPAN></SPAN>	AAW</SPAN>
8</SPAN>	D</SPAN>	5</SPAN>	1</SPAN>	B</SPAN>	BAL</SPAN>
9</SPAN>	C</SPAN>	1</SPAN>	3</SPAN>	B</SPAN>	BAW</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3><COL></COLGROUP>

 

[proficient]

simply want to say if Home Team is A, and Home Score is greater than Away Score, use AHW (A Home Win)


Only bothered about teams A & B so 8 possible combinations.

Hope someone can help me..

Thanks

	A	B	C	D	E
1	Home Team	HomeScore	Away Score	Away Team	Result
2	A	1	2	C	AHL
3	A	3	0	D	AHW
4	B	4	1	E	BHW
5	B	2	3	F	BHL
6	G	3	2	A	AAL
7	H	1	2	A	AAW
8	D	5	1	B	BAL
9	C	1	3	B	BAW

May be this...

Excel Workbook
	A	B	C	D	E
1	Home Team	Home Score	Away Team	Away Score	Result
2	A	3	P	2	AHW
3	B	2	O	1	BHW
4	C	6	L	4	CHW
5	D	5	T	3	DHW
6	E	4	E	5	EHL
7	F	2	Q	1	FHW
Sheet9

 

[JonesyUK]

Use the following formula in Cell F2 and copy down:

=IF(B2>C2,A2&"HW","")

Hope this helps.

 

[Robert Mika]

=if(or(a2={"a","b"}),a2&"h"&if(b2>c2,"w","l"),if(or(d2={"a","b"}),d2&"a"&if(b2>c2,"l","w")))

 

[proficient]

=if(or(a2={"a","b"}),a2&"h"&if(b2>c2,"w","l"),if(or(d2={"a","b"}),d2&"a"&if(b2>c2,"l","w")))

Are you sure the formula is working...?

Excel Workbook
	A	B	C	D	E
1	Home Team	Home Score	Away Team	Away Score	Result
2	A	3	P	2	Ahl
Sheet9

 

[Robert Mika]

Are you sure the formula is working...?
Sheet9

	A	B	C	D	E
1	Home Team	Home Score	Away Team	Away Score	Result
2	A	3	P	2	Ahl

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup>

Spreadsheet Formulas

Cell Formula E2 =IF(OR(A2={"a","b"}),A2&"h"&IF(B2>C2,"w","l"),IF(OR(D2={"a","b"}),D2&"a"&IF(B2>C2,"l","w")))

works here:

Excel Workbook
	A	B	C	D	E	F
1	Home Team	HomeScore	Away Score	Away Team	Result
2	A	1	2	C	AHL	Ahl
3	A	3	0	D	AHW	Ahw
4	B	4	1	E	BHW	Bhw
5	B	2	3	F	BHL	Bhl
6	G	3	2	A	AAL	Aal
7	H	1	2	A	AAW	Aaw
8	D	5	1	B	BAL	Bal
9	C	1	3	B	BAW	Baw
10	A	3	2	P		Ahw
Sheet1