Previous Topic Next Topic

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

Answer 1 / 1
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")))
Report

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