# golf card scoring

#### Jimbo328

##### New Member
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.

Jimbo

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
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

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.
Code:
``=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

Last edited:
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"))

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

*D24 should be -4 in the snapshot

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

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.

wooooo! i got it, thx all!

Replies
14
Views
557
Replies
6
Views
200
Replies
17
Views
266
Replies
5
Views
520
Replies
8
Views
104

1,203,101
Messages
6,053,535
Members
444,670
Latest member
laurenmjones1111

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back