Golf handicap calculation

[Marvo]

Hi. I'm trying to come up with a formula to work out golf handicaps on different courses. The English golf Union say this is how to do it.

Handicap Index® x (Slope Rating™ / 113) + (CR-PAR) = Course Handicap™ (Rounded)

So, how do you turn that into an excel formula?

As an example
The handicap index in A1 is 19.3.
The slope rating an A2 is 127
The CR in A3 is 68.8
Par in A4 is 69

The result in A5 should be 21

However if you change A1 to 19.4 then the result should be 22.

I can't get it to work.

Many thanks

 

[Cubist]

Looks like your answers are rounded.

Book1
	A
1	19.3
2	127
3	68.8
4	69
5
6	21.4911504
Sheet6

Cell Formulas
Range	Formula
A6	A6	=A1*(A2/113)+(A3-A4)

 

[Marvo]

Yes, they have to be. The problem is, in golf 16.4 = 16, 16.5 =17. However in the formula they give, that no longer applies. 19.3 = 21, 19.4 = 22. That's what I can't get my head round. Must be something to do with the multiply by 113.

 

[Cubist]

Yes, they have to be. The problem is, in golf 16.4 = 16, 16.5 =17. However in the formula they give, that no longer applies. 19.3 = 21, 19.4 = 22. That's what I can't get my head round. Must be something to do with the multiply by 113.

The typical rounding rule is if the decimal is 0.4 or under round down. If it's 0.5 or more round up.

Book2
	A
1	19.4
2	127
3	68.8
4	69
5
6	22
Sheet5

Cell Formulas
Range	Formula
A6	A6	=ROUND(A1*(A2/113)+(A3-A4),0)

 

[Marvo]

Having tested it on a few handicaps, that appears to be exactly what I need. Thank you.

The result becomes the source for two more calculations. At the moment both start with ROUND. Do I still need those or if I just copy the result would that be okay?

 

[Marvo]

Its okay, I've answered that myself by adding decimal points, they all produce .000000 so that's fantastic. Thank you very much

 

[Cubist]

You're welcome. I looked up their page. They say only the final answer is rounded. If they're used for another calculation, then it must be left un-rounded.

 

[Marvo]

Its okay, the first result gives you the handicap on the course, from that you work out your score so the rounded figure is fine.

The English Golf Union App works it out for you, that's what I checked a few handicaps against to see if we'd got it right (we have). However I run a society with 50 members and I didn't want to have to look at 50 different handicaps every time we play another course.

Anyway, thanks very much, that all solved 3 or 4 problems.