+ Reply to Thread
Results 1 to 4 of 4

Awarding Points Based on Game Results

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Awarding Points Based on Game Results

    I'm a complete newbie when it comes to excel and am trying to fumble my way through doing a basic spread sheet for our local bowling club where by points are allocated depending upon the result of a game. I know what I'm trying to achieve but the syntax for the appropriate formula has be scratching my head. These are the criteria to be met and I assume a series of nested "IF" and "AND" comparisons need to be used:-

    IF (A1 > A2) THEN 10
    IF (SCORE 1 IS > THAN SCORE 2) THEN AWARD 10pts


    IF (A2 > A1) THEN 0
    IF (SCORE 2 IS > THAN SCORE 1) THEN AWARD 0pts


    IF (A1 = A2) THEN 10
    IF (SCORE 1 = SCORE 2) [Drawn game] THEN AWARD 10pts


    IF (A1 + A2 = 0) THEN 0
    IF (SCORE 1 + SCORE 2 = 0) [Forfeited game] AWARD 0pts

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Awarding Points Based on Game Results

    hi Captain Legless, is this what you need?
    =IF(OR(A2>A1,SUM(A1:A2)=0),0,IF(OR(A1>A2,A1=A2),10,""))

    do explain if it doesn't work

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    02-29-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Awarding Points Based on Game Results

    Thanks benishiryo for a lightening fast reply, under 10 minutes from me posting the question!
    I do believe your solution works. I've quickly inserted it into my document and amended to to accommodate the cells that I'm using and it appears to be OK. I'll give it a workout tomorrow (it's almost midnight here) using various values and will see if I can break it.

  4. #4
    Registered User
    Join Date
    02-29-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Awarding Points Based on Game Results

    All good thanks!

+ Reply to Thread

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