Forum Discussion
EXCEL FORMULA
CURTIS775 Perhaps the attached schedule does what you ask for.
Created a table with points given for every score in relation to par. Par -1 = 5 pts, Par = 3 pts, Par +1 = 1 pt, Par +2 = 0 pts.
Then, if your Excel supports XLOOKUP you could calculate total points for the entire round in one single formula (in D28). But, perhaps you also want to show each player's points per hole. If XLOOKUP is not recognised by your Excel, you can use HLOOKUP. In both cases I have used named ranges to keep the formulae easier to read/maintain.
Note: You did not indicate how many points a player gets if he/she scores better then 1 under par on a hole. In the current set-up it will result in 0 or #NA!, but that can easily be fixed once you determine what the result should be.
Riny_van_Eekelen CURTIS775 wouldn't you be able to use a formula like:
=MAX(3 - 2 * (SCORE - PAR), 0)
That would give you:
Pts Score
0 >=2 over par (double bogie)
1 1 over par (bogie)
3 par
5 1 under par (birdie)
and in this case even better scores would follow as:
7 2 under par (eagle)
9 3 under par (double eagle)
but CURTIS775 needs to say if these would be correct scores or not.