+ Reply to Thread
Results 1 to 2 of 2

Help for formula please

Hybrid View

athullovzu Help for formula please 10-04-2012, 08:05 AM
vlady Re: Help for formula please 10-04-2012, 09:35 PM
  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    8

    Question Help for formula please

    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??

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Help for formula please

    Welcome to the forum.
    You can post a thread in ->Excel Formula/Function put an appropriate Title and if you can upload a sample workbook it's better.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

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