Previous Topic Next Topic

Nested if's

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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Oct 2012 à 16:45
=IF(AND(B1="",D1=""), "",IF(B1>D1,A1,IF(B1<D1,C1,"Tie")))
Juan Graciano
20 Oct 2012 à 19:07
Thank you very much It works exactly the way I wanted
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
21 Oct 2012 à 07:25
your are very welcome

Similar discussions

using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

3 responses