Formula for golf skin to get two strokes on any given hole

[VinceF]

I've searched the forum and I didn't find this particular problem. Assistance please with a formula to determine a golf "skin" when the players handicap is over 18.
The formula below makes the adjustment if the golfer is an 18 handicapper or below. But what if the golfers handicap is over 18, then he's entitled to 2 strokes on some holes.
Example: Joe's handicap is 26. This entitles him to 1 stroke on each of the 18 holes and Joe would get two strokes on handicap holes 1 thru 8
Thanks for your assistance.

IF($D$9>=U$5,Main!W12-1,IF($D$9<U$5,Main!W12))))
D9 is players handicap
U5 is the hole handicap
W12 is the players actual score for the hole

 

[DRSteele]

I think this might help.

MrExcel posts19.xlsx
	B	C	D	E	F	G	H	I	J
2			Golfer \ Hcap"	VinceF	26	DonS	7	JackN	0
3
4	Hole	Par	Hcap	Score	Net	Score	Net	Score	Net
5	1	4	8	7	5	5	5	3	3
6	2	4	11	6	5	5	5	4	4
7	3	5	10	8	7	5	5	4	4
8	4	3	1	5	3	3	2	3	3
9	5	4	4	5	3	3	2	4	4
10	6	4	18	7	6	4	4	4	4
11	7	3	2	4	2	3	2	3	3
12	8	5	9	5	4	7	7	4	4
13	9	4	3	6	4	4	3	4	4
14	10	4	13	6	5	5	5	4	4
15	11	5	12	7	6	7	7	6	6
16	12	4	14	4	3	4	4	4	4
17	13	4	15	5	4	4	4	3	3
18	14	3	5	6	4	2	1	2	2
19	15	4	6	7	5	4	3	4	4
20	16	4	17	4	3	5	5	4	4
21	17	3	16	2	1	4	4	3	3
22	18	5	7	8	6	3	2	4	4
23		72		102	76	77	70	67	67
Sheet9

Cell Formulas
Range	Formula
F5:F22	F5	=E5-(B5<=F$2)-(($F$2-18)>=D5)
H5:H22,J5:J22	H5	=G5-(D5<=H$2)
C23,E23:J23	C23	=SUM(C5:C22)

 

[DRSteele]

Oops, some problems occurred there. Ignore that one.

MrExcel posts19.xlsx
	B	C	D	E	F	G	H	I	J	K
1
2			Golfer \ Hcap"	VinceF	26	DonS	7	JackN	0
3
4	Hole	Par	Hcap	Score	Net	Score	Net	Score	Net
5	1	4	8	7	5	5	5	3	3
6	2	4	11	6	5	5	5	4	4
7	3	5	10	8	7	5	5	4	4
8	4	3	1	5	3	3	2	3	3
9	5	4	4	5	3	3	2	4	4
10	6	4	18	7	6	4	4	4	4
11	7	3	2	4	2	3	2	3	3
12	8	5	9	5	4	7	7	4	4
13	9	4	3	6	4	4	3	4	4
14	10	4	13	6	5	5	5	4	4
15	11	5	12	7	6	7	7	6	6
16	12	4	14	4	3	4	4	4	4
17	13	4	15	5	4	4	4	3	3
18	14	3	5	6	4	2	1	2	2
19	15	4	6	7	5	4	3	4	4
20	16	4	17	4	3	5	5	4	4
21	17	3	16	2	1	4	4	3	3
22	18	5	7	8	6	3	2	4	4
23		72		102	76	77	70	67	67
Sheet9

Cell Formulas
Range	Formula
F5:F22,J5:J22,H5:H22	F5	=E5-($D5<=F$2)-((F$2-18)>=$D5)
C23,E23:J23	C23	=SUM(C5:C22)

 

[VinceF]

DRSteele,
Thank you for the reply and suggestion. I'm going to try and make this work and I'll let you know how it does.

Thanks again,
VinceF

 

[VinceF]

DRSteele,
Thank you for the reply and suggestion. I'm going to try and make this work and I'll let you know how it does.

Thanks again,
VinceF

As a follow up... your formula is working fine, I very much appreciate your assistance.