Excel Formula to determine a winner team

[gary2014]

Hi Team,

Please help with a command to achieve the following:
1) I want the "

Winning Team" to populate in that column depending on scores of Team A & Team B.​

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Match No[/TD]
[TD="align: center"]Team A[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Team B[/TD]
[TD="align: center"]Score Team A[/TD]
[TD="align: center"]Score Team B[/TD]
[TD="align: center"]Winning Team[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Kings College[/TD]
[TD="align: center"]Vs[/TD]
[TD="align: center"]Royal College[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]Plz help me with the code[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]AV College[/TD]
[TD="align: center"]VS[/TD]
[TD="align: center"]Royal College[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]Plz help me with the code[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Kings College[/TD]
[TD="align: center"]VS[/TD]
[TD="align: center"]AV College[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]Plz help me with the code[/TD]
[/TR]
</tbody>[/TABLE]

2) I want the "

Winner and Runner" to populate in two different columns depending on cumulative scores.​

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]***[/TD]
[TD="align: center"]Kings College[/TD]
[TD="align: center"]Royal College[/TD]
[TD="align: center"]AV College[/TD]
[TD="align: center"]Cumulative Score[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]Winner Team[/TD]
[TD="align: center"]Runner Up Team
[/TD]
[/TR]
[TR]
[TD="align: center"]Kings College[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]80[/TD]
[TD="align: center"][/TD]
[TD="align: center"]--??--[/TD]
[TD="align: center"]--??--[/TD]
[/TR]
[TR]
[TD="align: center"]Royal College[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]76[/TD]
[TD="align: center"][/TD]
[TD="align: center"]xxxxxxx[/TD]
[TD="align: center"]xxxxxxxx[/TD]
[/TR]
[TR]
[TD="align: center"]AV College[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]49[/TD]
[TD="align: center"][/TD]
[TD="align: center"]xxxxxxx[/TD]
[TD="align: center"]xxxxxxxx[/TD]
[/TR]
</tbody>[/TABLE]

 

[brihar77]

Great formula!! How do you modify this formula so that G2 will stay blank when e2 and f2 are blank? Thanks!!