tonialta · F
For what
ShenaniganFoodie · 36-40, M
@tonialta Golf Handicap NEED a Formula
gross score 77 ( every score over 72 base score ) get 0.2 added = 72.2
gross score 69 ( base score 72 ) 3 under = 3 x 0.2 = 0.6 = 71.4
gross score 77 ( every score over 72 base score ) get 0.2 added = 72.2
gross score 69 ( base score 72 ) 3 under = 3 x 0.2 = 0.6 = 71.4
@ShenaniganFoodie We would also need to need to know the columns that the scores are in.
Let's say name goes in column A and the scores go into column B.
Then the formula, for what I think you want would've something like
=((B1-72)*0.2)+72
So if 77 it would be
((77-72)*0.2)+72
(5*0.2)+72
1+72
73.0
So if 69 it would be
((69-72)*0.2)+72
(-3*0.2)+72
-.6+72
71.4
Let's say name goes in column A and the scores go into column B.
Then the formula, for what I think you want would've something like
=((B1-72)*0.2)+72
So if 77 it would be
((77-72)*0.2)+72
(5*0.2)+72
1+72
73.0
So if 69 it would be
((69-72)*0.2)+72
(-3*0.2)+72
-.6+72
71.4
ShenaniganFoodie · 36-40, M
@sstronaut Thanks, I got the formulas from Nuno
I might help, but you just reported me for no reason... just because you didn't understand.
I didn't need Nuno...
Now what about Excel?
I didn't need Nuno...
Now what about Excel?