Forum Discussion

cleantrousers's avatar
cleantrousers
Copper Contributor
Jul 02, 2022
Solved

multiple IF formulas in a single cell

Hello,   I am trying to create a ss that works out a stapleford score for golf using the par, stroke index and gross score. Easy to work out which holes I get one shot on and which I get two. My pr...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 02, 2022

    cleantrousers Please find a Golf score card attached. I created it a while ago when a similar question came up in this forum.

     

    Enter the course details (hole, index, par), your playing handicap and your gross scores for each hole. The schedule calculates the Strokes Received (SR) and points (Pts) per hole.

     

    The points calculation doesn't require nested IF functions. It follows the following rule:

     

    Pts = the greater of zero or ( 2 + Par + SR - Score )

     

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 02, 2022

cleantrousers Please find a Golf score card attached. I created it a while ago when a similar question came up in this forum.

 

Enter the course details (hole, index, par), your playing handicap and your gross scores for each hole. The schedule calculates the Strokes Received (SR) and points (Pts) per hole.

 

The points calculation doesn't require nested IF functions. It follows the following rule:

 

Pts = the greater of zero or ( 2 + Par + SR - Score )

 

 

Resources