Ok here's the story.
I'm making a spreadsheet for the Red Sox season record. I have multiple information being decided just from the scores, as in; the record for Vs East, Vs West, etc.
I have all of those being counted correctly. However I want to go one step farther with determining the winner of the game.
Right now in Colum F I have two differently formulas. If Boston is home then I have the following formula:
=IF(AND(D2="", E2=""),"",IF(D2<E2,"Win", "Loss"))
If there away I have the following formula:
=IF(AND(D5="", E5=""),"",IF(D5>E5,"Win", "Loss"))
While that works for me, I have to manually put that formula in there deciding upon if their home or away.
What I want to be able it to do is:
If D2 and E2 are blank then nothing else. If B2 equals home than (the home formula) or if B2 equals away than (the away formula).
The reason I want this is I want to be able to give this to my friends who only need to input the data, not the formulas.
Bookmarks