HI All,
Using the current College World Series to have fun with some formulas. As you can see from the screenshot below, I'm trying to write a formula in cell H123 that will allow it to select the winning team based on the scores I enter in column G.
So, I've started with "if G120 is empty, leave H123 empty. What I'm then trying to say is (because it's a double elimination tourney) if Arizona beats Vandy in game 1 (so, if G126>G120) to still leave H123 blank but if Vandy beats Arizona (G120>G126) to put Vandy as the winner. Then, after the 2nd game, whomever has the highest score of that game is the winner.
Summary: if no scores entered, leave H123 blank. If top teams wins 1st game, enter top team name in H123. If bottom team wins first game, leave H123 blank. Whomever wins game 2, enter that team in H123.
When I test it the way it's written now, H123 remains blank if nothing is entered, and correctly puts Vandy if I have them winning. If Arizona wins the 1st game, H123 correctly remains blank too. But nothing happens when I put scores in the 2nd game.
Using the current College World Series to have fun with some formulas. As you can see from the screenshot below, I'm trying to write a formula in cell H123 that will allow it to select the winning team based on the scores I enter in column G.
So, I've started with "if G120 is empty, leave H123 empty. What I'm then trying to say is (because it's a double elimination tourney) if Arizona beats Vandy in game 1 (so, if G126>G120) to still leave H123 blank but if Vandy beats Arizona (G120>G126) to put Vandy as the winner. Then, after the 2nd game, whomever has the highest score of that game is the winner.
Summary: if no scores entered, leave H123 blank. If top teams wins 1st game, enter top team name in H123. If bottom team wins first game, leave H123 blank. Whomever wins game 2, enter that team in H123.
When I test it the way it's written now, H123 remains blank if nothing is entered, and correctly puts Vandy if I have them winning. If Arizona wins the 1st game, H123 correctly remains blank too. But nothing happens when I put scores in the 2nd game.