golf scorecard

[dawesy]

i am trying to get a formula to score a golf scorecard where you put in the score for each hole and the program sorts out the score say if a par 4 is played as par and index is 4 and the handicap is 8 player does not get a shot on hole so he only scores a 4, and 2 points if he gets a shot on the hole he would score 4, and 3 points this would 

[#2]

@phil49

 Hi Phil49 just a quick percentage system to alter 66% of a handicap by altering the minus for a plus you can add the percentage aswell

have you got cells to put the formula in 

Ian

[#3]

@phil49 

hi there again have put a percentage formula in the scorecard i am sending you all set up all 

you need to do is put you handicaps in it gives you the new handicap in column D and leaves original

in column B rest of should be easy hope it works for you

Ian

[#4]

Thanks very much ill see how its go's,
thanks
phil

[#5]

@volvoxc70 

Hi there just looking at the scorecard i sent before found a fault in it so have redone it again this time 

entered the formula in the handicap column and changed the other columns now it works for both

stroke and stableford games. Just a matter of interest what game do you play with reducing handicaps 

by 60% would like to know 

Regards Ian

[#6]

It's a Winter Eclectic match 50 players

[#7]

you can easily make a best cavity back golf irons charts and also other things charts individually it is so easy to do. Not a big deal