Previous Topic Next Topic

Nested if's

Solved/Closed
Juan Gracinao
Posts
1
Registration date
Saturday October 20, 2012
Status
Member
Last seen
October 20, 2012
 - Oct 20, 2012 at 03:12 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Oct 21, 2012 at 07:25 AM
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

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Oct 20, 2012 at 04:45 PM
=IF(AND(B1="",D1=""), "",IF(B1>D1,A1,IF(B1<D1,C1,"Tie")))
0
Juan Graciano
Oct 20, 2012 at 07:07 PM
Thank you very much It works exactly the way I wanted
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Oct 21, 2012 at 07:25 AM
your are very welcome
0