Results 1 to 12 of 12

Formula required to calculate points for football results prediction

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    Watford, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Formula required to calculate points for football results prediction

    Hi there

    I'm creating an (English) football predictions competition for me and my family.

    One problem that has stumped me is how to get the scores based on the 'home' & 'away' score predictions.

    The rules are: If I predict the correct exact result I get 3 points. I want to add another 'rule' whereby if I predict the correct winner, I get 1 point. Incorrect predictions get 0 points. I don't know how to do this using a formula.

    Please can someone tell me what I need to write? The online Microsoft Excel 2007 help only confused me further! Please see the example spreadsheet attached; I've added examples and explanations of what the scores should be...

    I can offer PowerPoint assistance in return; Excel is not my area of expertise!

    Many thanks
    Jenny
    Attached Files Attached Files
    Last edited by Jen1979; 08-02-2009 at 12:56 PM. Reason: amend to more appropriate title

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