+ Reply to Thread
Results 1 to 4 of 4

True, False and equal

  1. #1
    Registered User
    Join Date
    08-26-2007
    Posts
    2

    Talking True, False and equal

    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.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Try this,

    Please Login or Register  to view this content.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    08-26-2007
    Posts
    2
    EXCELLENT!!!! Thank you so much - that has had me baffled for the past hour!!!

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Glad to help - thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1