Update
Only logged in members can reply and interact with the post.
Join SimilarWorlds for FREE »
Top | New | Old
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
@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
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?

 
Post Comment