# Awarding Points Based on Game Results

1. ## 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. ## 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

3. ## 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. ## Re: Awarding Points Based on Game Results

All good thanks!

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

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