+ Reply to Thread
Results 1 to 3 of 3

If all values match to - come back with a result function

  1. #1
    Registered User
    Join Date
    12-16-2004
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    34

    Question If all values match to - come back with a result function

    Hi all

    I know this one is an easy one, but my head got stuck. I am doing a football tipping table where if all the bets won then I need Excel to come back with the word "WON", but if at least one be is lost, then to come back with the word "LOST".

    A couple of examples. Let's I have bet in four different football games as per below and all of them were predicted correctly.
    GAME1: WON
    GAME2: WON
    GAME3: WON
    GAME4: WON
    -------------
    BET OUTCOME: WON

    But even at least one of the is lost, the the whole bet should be lost.
    GAME1: WON
    GAME2: LOST
    GAME3: WON
    GAME4: WON
    -------------
    BET OUTCOME: LOST

    As per image below, I need the bet outcome to appear in cell J2
    2019-06-01_12-03-03.png

    PS: I have an Exce file with the example but for some reason the attachments button is not working so I will upload it here -> https://file.io/IpbNbk

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: If all values match to - come back with a result function

    Please try at K2
    =If(countif(K3:K6,"LOST"),"LOST","WIN")

  3. #3
    Registered User
    Join Date
    12-16-2004
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    34

    Re: If all values match to - come back with a result function

    Quote Originally Posted by Bo_Ry View Post
    Please try at K2
    =If(countif(K3:K6,"LOST"),"LOST","WIN")
    It did work. Thanks for that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index/Match Function for Finding Result in between Two Values with Two Criteria
    By KyleElliott in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2017, 01:19 AM
  2. Pass function result to cell, not back to sub
    By GCW esq in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-02-2014, 05:29 PM
  3. INSERT/MATCH Function - can I match and return more than a single result?
    By nickwee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2014, 06:02 AM
  4. Match any two values for result
    By jewnaa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2014, 03:46 PM
  5. [SOLVED] MATCH function - unexpected #NA result
    By broncotundra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2013, 08:52 PM
  6. Match multiple columns to bring back one result
    By amyj22x3 in forum Excel General
    Replies: 3
    Last Post: 08-22-2011, 03:04 PM
  7. Replies: 7
    Last Post: 06-09-2011, 05:25 PM

Tags for this Thread

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