golf card scoring

[Jimbo328]

Hi,

I'm trying to build a golf scoring card, in which if person A scores a lower score than person B, then player A gets +1points and player B gets -1 point. If however, player A shoots below par --> birdie = player A gets double the points +2, eagle = player A gets +4, while player B gets -2points for birdie, and -4points for eagle. If the two players tie in shots, then a "E" will appear.

so far, my formula is like this (unable to get "E" and +2/-2 for birdie, +4/-4 for eagle):

=IF(C5=C8,"E",IF(C5<C8,"+1","-1")) with C5 being what player A shoots, and C8 being what play B shoots.

Thx in advance,

Jimbo

 

[Michael M]

Hi Jimbo and welcome to the Board
First question....how will excel know what the par for the hole is ??
Where are you storing the scores for each player if C5 is player 1 and C8 is player 2
I'm guessing your going to need two sets of formulae, one for player A and one for player B

 

[Michael M]

Assuming the par for the hole is in column "B", you could try
this for Player 1.
It will return a Blank, if none of the conditions apply.

=IF(AND(C5< C8,C5< B5-1),4,IF(AND(C5< C8,C5< B5),2,IF(C5< C8,1,IF(C5=C8,"E",""))))

You'll need to remove the spaces after each < in the formula

 

[Jimbo328]

thank you for the prompt response. the formula i've suggested earlier is incomplete, its suppose to be:

=IF(C5=C8,0,IF(C5<c8,"+1","-1"))
(edit: cannot seem to upload the formula)

yes you are correct, there are another set of numbers that reveal it is under or above par. However, it doesn't quite matter how many strokes are won or not. The purpose of the spread sheet is really to keep track of who wins the hole. As long as player A beats player B in that hole, then it equals +1 for player A; in the event that player A wins the hole with a birdie, then it is +2 for player A (-2 for player B). If player A beats player B with a eagle (does not matter how many strokes he beats him by), then it is +4 for player A and -4 for player B.

Perhaps the snapshot explains my purpose a little clearer (I've removed all the formulas and inputted the numbers manually to show my point)

Best Regards,
Jimbo</c8,"+1","-1"))

 

[shg]

Put a space after the < so it's not interpreted as the opening of an HTML tag.

 

[Jimbo328]

*D24 should be -4 in the snapshot

 

[Michael M]

OK, did you try the formula I provided.
Apart, from cell references, it should as required.

 

[Jimbo328]

I've tried

=IF(AND(C5< C8,C5< B5-1),4,IF(AND(C5< C8,C5< B5),2,IF(C5< C8,1,IF(C5=C8,"E","")))) , and it returns blank.

I don't really need the program to understand if its par or not; i simply want to put, if player A wins the hole with -1 for strokes, then its +2points for him against the other plays whos lost to them, if -2 strokes, then +4points, all else will be +1point if he wins with 0strokes, 1strokes, 2strokes, 3 strokes, etc. If player A and player B both shoot -1 stroke, then a "EVEN" will show. ​

 

[Jimbo328]

wooooo! i got it, thx all!