Forum Discussion

dawesy's avatar
dawesy
Brass Contributor
Mar 03, 2022

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 ...
Excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 09, 2022

    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!

phil49's avatar
phil49
Copper Contributor
Oct 30, 2022
Hi am trying to put % on my golf scorecard ie: take off 60% of the handicap
  • dawesy's avatar
    dawesy
    Brass Contributor
    Oct 31, 2022

    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

  • dawesy's avatar
    dawesy
    Brass Contributor
    Nov 03, 2022

    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

    • volvoxc70's avatar
      volvoxc70
      Copper Contributor
      Nov 03, 2022
      Thanks very much ill see how its go's,
      thanks
      phil
      • dawesy's avatar
        dawesy
        Brass Contributor
        Nov 03, 2022

        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

Resources