- Joined
- Dec 21, 2009
- Messages
- 1
- Reaction score
- 0
I am running a college football bowl game pick em for me and some friends and am working on an easy way to figure the winners.
Column A: Favored Team (Alabama)
Column B: Spread (-5)
Column C: Underdog (Texas)
Column D: Favored Teams Score (31)
Column E: Underdog Score (28)
Column F: Winner (Player A or Player B)
I know for column F i can use IF(D1+B1>E1,"player a","playerb")
Questions
1. This basic formula automatically shows a winner(player a or player b) even when the game is in the future and no scores have been inputed.
2. I would like to know how to add a fuction for a Tie. If D1+B1=E1 I would like for it to say Tie in the winner cell.
Thanks in advance.
Go Gators!
Column A: Favored Team (Alabama)
Column B: Spread (-5)
Column C: Underdog (Texas)
Column D: Favored Teams Score (31)
Column E: Underdog Score (28)
Column F: Winner (Player A or Player B)
I know for column F i can use IF(D1+B1>E1,"player a","playerb")
Questions
1. This basic formula automatically shows a winner(player a or player b) even when the game is in the future and no scores have been inputed.
2. I would like to know how to add a fuction for a Tie. If D1+B1=E1 I would like for it to say Tie in the winner cell.
Thanks in advance.
Go Gators!