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?
