Winning Team Formula

[bluenose5709]

Hi

I hope someone can help me with what is most likely a simple formula:

I would like for Cell "N2" to determine which is the higher value between "L2" & "M2" and return the name accordingly, I would also like for it to return "DRAW" if there is no clear winner

Thank you

 

[Phuoc]

Try this:

Book1
	L	M	N
1	Blue	Red
2	8	9	Red
3	9	9	DRAW
Sheet1

Cell Formulas
Range	Formula
N2:N3	N2	=IF(L2=M2,"DRAW",IF(L2>M2,$L$1,$M$1))

 

[Fluff]

How about

=CHOOSE(SIGN(L2-M2)+2,M1,"Draw",L1)

 

[bluenose5709]

How about

=CHOOSE(SIGN(L2-M2)+2,M1,"Draw",L1)

Fluff

Perfect,

Thank you

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[bluenose5709]

Glad we could help & thanks for the feedback.

Fuff,

The help from this community is fantastic. thank you.

I wonder if you could tweak your working formula slightly so that if the values displayed in "L2" & "M2" were both 0 then return nothing ...?

For context, I have a worksheet to record competitions and respective points, these tables are duplicated many times within the sheet so that they may be populated as a new competition is run and total overall points correlated for individuals and against teams.

Whilst your formula is working exactly how I have requested, it is picking up the "0" as a draw, hence the screen shot below shows red as having a point because i have inserted the formula but the competition have not yet run. I need for it to ignore "0" so that at the start the field is blank.

* I have configured the spreadsheet to not show 0's hence they are not showing in the screenshot

Thank you

 

[Fluff]

Could you have a result where both teams score 0?

 

[bluenose5709]

Simply put, no. the majority of the time the competition will be individual, even though they are part of a team, simply participating will result in 1 point so if there were only two participants, with one from either team the lowest score would be 1 : 1

the only time that 0 : 0 Occurs is before a competition has taken place on the basis that my points column is populated by a formula and blanks return 0, hence i have hidden all 0s

 

[Fluff]

Ok, how about

=IF(SUM(L2:M2)=0,"",CHOOSE(SIGN(L2-M2)+2,M1,"Draw",L1))

 

[bluenose5709]

Fluff,

Perfect, thank you once more