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
Bookmarks