Hole handicap

[cia2a629]

I am looking to have cards with each golfers handicap strokes per hole. the formula I have has a flaw I can't fix. I want to be able to enter the formula on different courses and only change the hole handicap per course.
=IF(B10<0,0,IF(B10<18,1,IF(B10<36,2,3)))-B8

Course Name:		PINE HOLLOW GOLF CLUB
Hole		1	2	3	4	5	6	7	8	9	Out
Gold 68.0/125		340	464	169	332	131	242	359	382	348	2767	No Stroke		o
Red 69.0/122		305	394	137	310	114	222	332	322	317	2453	1 Stroke
Hcp.		13	9	11	7	15	17	3	1	5		2 Strokes		.
Par		4	5	3	4	3	4	4	5	4	36
Jim Shue	Hndcp											Birdey		4
5	5	-3										Par		2
George Jones												Bogey		1
18	18											Dbl. Bogey		0
Nate Johnson												Trip. Bogey		-1
20	20	6
Jack Bean
29	29	6
TEAM TOTAL
TEAM POINTS

 

[AhoyNC]

That's it!

 

[Fluff]

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Strokes per hole
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[cia2a629]

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Strokes per hole
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

I did not know these were the same, one is called MRExcel and the other says Excel Forum. It is a bit confusing with no clarification. You can just remove me from both if it makes you happy. Jeez

 

[Fluff]

I did not know these were the same,

They aren't. Try reading this to understand abut cross posting Excelguru Help Site - A message to forum cross posters

 

[cia2a629]

They aren't. Try reading this to understand abut cross posting Excelguru Help Site - A message to forum cross posters

Point Made , and Point taken.