sports spreadsheet to show W/L automatically

[pdjarr]

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.

[TABLE="width: 125"]
<tbody>[TR]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]W / L[/TD]
[TD]H[/TD]
[TD]V[/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]14[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]17[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]28[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Wins[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Losses[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col span="2"></colgroup>[/TABLE]


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?

 

[Logit]

.
Here's one method :

=IF(F3="","",IF(F3>G3,"W","L"))

 

[pdjarr]

That works perfectly! Thank you very much!

 

[Logit]

.
You are welcome