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.
Also will the cell address where I enter the score need to entered in this formula.
Example
The score goes in c5
I want the points to wind up in c26
CURTIS775 and where is the Par value. It would be best to include a sample sheet because Par would be listed 1x per hole but there will be multiple players so the references will have to be a mix of relative and absolute references.
When applying the formula you suggest, which cell would I put this formula, The one where I want the points to end up?
mtarler Sure, that would also work.
