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 han...
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.