Nested Formula - Microsoft Community

can 1 please. run golf society , wish calculate handicaps excel. can understand if formula give me info on needs adjusting. see below. can me calculate new h/p in g5. wish make -0.2 per point above 36pts. in d5 score of 41 5 points better 36. therefore adjustment should 1 point. don't know how enter nested formula. 

many in anticipation. revwalker 

names	exact h/p	h/p	points	minus h/p	plus h/p	new ex	winner	new h/p
			36	30 -	36 +	h/p	lose 2pts
				0.2 +	0.2 -
					yes
matt e	9.2	9	41	0.0	-0.2
matt w	9.2	9	27	+0.2	0
tez	9.2	9	33	0.0	0
rev	9.2	9	42	0.0	-0.2
carne	9.2	9	45	0.0	-0.2
killian	9.2	9	36	0.0	-0.2
ollie	9.2	9	38	0.0	-0.2
pete o	9.2	9	39	0.0	-0.2
pete p	9.2	9	25	+0.2	0
jocky	9.2	9	24	+0.2	0
neil	9.2	9	39	0.0	-0.2
nick	9.2	9	40	0.0	-0.2
colin c	9.2	9	28	+0.2	0
colin b	9.2	9	36	0.0	-0.2
john griff	9.2	9	37	0.0	-0.2
kier	9.2	9	23	+0.2	0
simon	9.2	9	30	+0.2	0
baz	9.2	9	33	0.0	0
paul	9.2	9	36	0.0	-0.2
alan pett	9.2	9	41	0.0	-0.2

this should want. put in cell g5 , copy down:

=if(d5>$d$2,(d5-$d$2)*0.2)

Office / Excel / Windows 10 / Office 2016