Can anyone help? I'm trying to perform a function where there are 3 outcomes: True, False and Equal. What I want is based on football results. I want to be able to enter one score in a cell, and another score in another cell. I then want the following to happen: If the first cell is greater than the secong it says Home, if the first cell is less than the second it says Away and if both cells are equal it says Draw. I've managed to get Home and Away to work by using IF, but this doesnt allow an equal result to occur. I've used the following:
=IF(F6>G6,"Home","Away")
Does anyone know anything I can add to this to enable a third option being "Draw" should the results be equal??
Thank you in advance for your help.
Bookmarks