Results 1 to 19 of 19

Formula for football league

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    8

    Question Formula for football league

    Hello everyone..

    i was making one excel sheet for football score prediction league. the rule is to to award 10 points for the exact correct result. ( ex Correct result 2-1, Predicted result 2-1)
    then 8 points for correct match result and correct goal difference (ex Correct result 3-2, Predicted result 2-1, since the match result is same and the goal difference is also same, 8 points)

    3 points for the correct match result ( ex Correct result 3-2, Predicted result 1-0)

    0 for wrong result

    please help me in this... i need excel formula for this...

    if correct result is predicted in B2 AND C2, and Predicted result in B3 AND C3... What FORMULA'S CAN I USE??
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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