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 4478 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.



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 21, 2012 at 07:25 AM
your are very welcome
0

Similar discussions

Nested IF functions using time values
SharkMerry -
Harshada Chaudhari -

5 responses