Forum Discussion
Score Sheet
=IF(J5=0,0,IF(J5>24,-1,IF(J5<24,1,IF(J5=24,0,))))
Hi there
Above is my attempt for a golf score record using the IF command. My problem is this:
If a player scores less than 24 points his his handicap goes up one
If he scores 25-27 points his score stays the same
if he scores 28 he gets one point deducted from his handicap
29 he gets 2 points taken off his handicap
30 he gets 3 points taken off his handicap
31 -4points
32 minus
ianshaw2 What an odd system. I guess you'll use if for fun among friends. Anyhow, I would create a table with the lower boundaries for each handicap adjustment. Then use LOOKUP to find the adjustment for each score. No need for complicated nested IF formulas.
Example attached.
