Trouble with a formula for an NFL picks sheet

[bgry66]

Have been doing an NFL picks sheet for about 5 years and decided to redo it from scratch. Problem I'm having is I want it to auto calculate a W for wins and an L for losses based on it comparing the persons pick (cell G3) to the games winner (cell F3). This part works fine.... here's the formula I'm using right now in cell H3 =IF(G3=F3,"W","L") This formula returns the outcome to cell H3 and so on down the column for all 16 games each week and totals all W's & L's at bottom of sheet (no problems) Here is my problem, since G3 & F3 are still equal to each other when they are blank (before people pick their games & before the games outcome is decided) it gives everyone a "W" every game & then gives everyone an "L" when they make their picks before the games are played because the cell G3 & F3 are no longer equal to each other. What can I do in the formula to return something other than a "W" when blank or "L" when people make picks so it won't calculate at the bottom as 16-0 or 0-16 before outcome of game?




Hope I explained this well enough, it's my first time on here.
Thank You,
bgry66

 

[Chris Mack]

How about this:

=IF(OR(F3="",G3=""),"Alternative result goes here",IF(G3=F3,"W","L"))

Hope this helps,

Chris.

 

[bgry66]

Works like a charm, I replaced the "alternative result" to return a blank cell ("") now everyone's records are 0-0 like they should be before the games are played.
Thanks a lot......
bgry66

 

[Chris Mack]

Yw!