Return a value based on another 4 four cells

[subtotalatom]

Hello,

i need a formula to return a value based on 4 cells in different rows.

if the four cells have "W" in them then the collumn AA will retun a W. however if one of more Cells have L in them then it returns a L

KBJM Bet Club Tracker.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
14	27/04/2021	Cowdenbeath	Scotland Other	1.67	£5		W	Halifax			£5		W	Brentford	England Championship	1.57	£5		W	Charlton			£5		W		#NAME?
Bet Tracker

Cell Formulas
Range	Formula
AA14	AA14	=IF((AND(G14=W,M14=W,S14=W,Y14=W)),"W","L")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:G9,M2:M9,S2:S9,Y2:Z9,Y122:Z144,S122:S144,M122:M144,G122:G144,Y76:Z76,S76,M76,G76,Y11:Z31,S11:S31,M11:M31,G11:G31	Cell Value	="L"	text	NO
G2:G9,M2:M9,S2:S9,Y2:Z9,Y122:Z144,S122:S144,M122:M144,G122:G144,Y76:Z76,S76,M76,G76,Y11:Z31,S11:S31,M11:M31,G11:G31	Cell Value	="W"	text	NO

 

[McGuilliam]

If I understand correctly, you could try:

=if(and(G2="W";M2="W";S2="W";Y2="W");"W";if(or(G2="L";M2="L";S2="L";Y2="L");"L";""))

Just copy this to A2 and pull it down the range you need.

 

[JimM]

You're just missing some quote marks

=IF(AND(G14="W",M14="W",S14="W",Y14="W"),"W","L")

 

[subtotalatom]

Thankyou Gents,

You're just missing some quote marks

=IF(AND(G14="W",M14="W",S14="W",Y14="W"),"W","L")

how do i get it return blank if no value is entered?

 

[Fluff]

Another option

=IF(G14&M14&S14&Y14="WWWW","W","L")

 

[Fluff]

For all blanks try

=IF(G14&M14&S14&Y14="","",IF(G14&M14&S14&Y14="WWWW","W","L"))