Nested if's

[Solved/Closed]
Report
Posts
1
Registration date
Saturday October 20, 2012
Status
Member
Last seen
October 20, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I would appreciate if somebody could help me in solving this problem.
I am trying to make exel decide in an scheduled soccer games which team is the winner.
Situation:
A1= home team B1= home team score C1=Visiting Team D1= Visiting team Score.
I would like to have the name of the winner teams ina list of home teams and other of visiting teams.
If there is no possible answer still I thank you verry much for taking the time to read my question.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
=IF(AND(B1="",D1=""), "",IF(B1>D1,A1,IF(B1<D1,C1,"Tie")))

Thank you very much It works exactly the way I wanted
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
your are very welcome