# golf scorecard

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

dawesy You need to incorporate the "strokes received" formula into the overall points calculation. To calculate all in one formula is possible but the formula becomes quite complex. Better to add a row for each player where the points per hole are calculated and then added up in the end. You can alway hide these extra rows if you want.

I took the liberty of changing some formats in your sheet ğŸ™‚

Enjoy your golf!