+ Reply to Thread
Results 1 to 4 of 4

Football prediction league help

  1. #1
    Registered User
    Join Date
    12-01-2013
    Location
    Londonish
    MS-Off Ver
    Excel 2010
    Posts
    4

    Football prediction league help

    Hi there peeps. I'm new to this place but thought you guys could help me out with my Prediction league on excel 2010.
    I used one of the formulas posted on this site which worked nicely with couple of minor tweaks, however I'm struggling with a couple of bits.
    How can I stop excel counting blank cells as 5 points (cell I7 in the image should be 0 or preferably blank)
    I have managed to do it by putting underscores, full stops and commas in so the formula dosen't count it as the same

    predo.jpg

    Many thanks, Al

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,791

    Re: Football prediction league help

    There is not much point in attaching a picture of your file, as we can't see what is in the various cells - attach the file itself, and explain clearly what you would like to do.

    Pete

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Football prediction league help

    If you use this version you get a blank result unless both results (prediction and actual) are fully filled-in

    =IF(COUNT(G7,H7,K7,L7)=4,IF(AND(G7=K7,H7=L7),5,IF(SIGN(G7-H7)=SIGN(K7-L7),2,0)),"")

    If both prediction and actual are populated then you get 5 points for an exact score match, 2 for a correct result, 0 otherwise
    Audere est facere

  4. #4
    Registered User
    Join Date
    12-01-2013
    Location
    Londonish
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Football prediction league help

    Wow thanks a lot for that.. Just what I needed. I hope you get paid well

+ 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. football prediction game help
    By richardw123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-01-2013, 09:29 AM
  2. [SOLVED] Football Prediction help!!
    By Welsh in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-21-2012, 12:47 PM
  3. Excel 2007 : football prediction game
    By JediMaster in forum Excel General
    Replies: 0
    Last Post: 06-15-2010, 05:53 PM
  4. Help for my football prediction game
    By 1.zer0 in forum Excel General
    Replies: 8
    Last Post: 06-13-2010, 01:06 PM
  5. Formula help for Football prediction League
    By Superkev2910 in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 09:18 AM

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