I'm trying to improve a sports spreadsheet that I've built. I want the win/loss to show automatically based on the score of the game each week. I have column E win/loss, column F team score, column G opponent's score. I have the overall record totaling itself already.
I could do =IF(F3>G3,"W","L") in each row, but that results in an errant "L" for games that haven't been played yet. This in turn messes up the overall record. Here's what I have right now.
<tbody>
</tbody><colgroup><col><col span="2"></colgroup>
The record should be 2-1 not 2-4. Is there a way to get the "W" or "L" to show only if a game has been played? To only show the "W" or "L" in column E if there's a value/score entered in columns F and G?
I could do =IF(F3>G3,"W","L") in each row, but that results in an errant "L" for games that haven't been played yet. This in turn messes up the overall record. Here's what I have right now.
E | F | G |
W / L | H | V |
W | 14 | 3 |
L | 17 | 22 |
W | 28 | 25 |
L | ||
L | ||
L | ||
Wins | 2 | |
Losses | 4 |
<tbody>
</tbody><colgroup><col><col span="2"></colgroup>
The record should be 2-1 not 2-4. Is there a way to get the "W" or "L" to show only if a game has been played? To only show the "W" or "L" in column E if there's a value/score entered in columns F and G?