Hi
I'm trying to find a formula that will add a Win or Lose value depending if a team won or lost their game. I've attached an example. How I have it currently is under the Start sheet and how I want it to look is under the Finish sheet.
Thanks!
Hi
I'm trying to find a formula that will add a Win or Lose value depending if a team won or lost their game. I've attached an example. How I have it currently is under the Start sheet and how I want it to look is under the Finish sheet.
Thanks!
For Home (E2):
=IF($C2<$D2,"L","W")
For Away (F2):
=IF($C2>$D2,"L","W")
and dragged down as necessary
regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks