Forum Discussion
Excel "IF" function
Hey Hans,
Yes that’s exactly what IF is for.
Assuming:
- Stableford points are in A2
- Current handicap is in B2
Put this in a new column (e.g., C2 = New Handicap):
=IF(A2<30, B2+1, B2)
What it does:
- If Stableford points are < 30, return handicap + 1
- Otherwise, return the same handicap
If you want it to stay blank when there are no points entered yet (common in score sheets):
=IF(A2="", "", IF(A2<30, B2+1, B2))
spreadsheets generally shouldn’t “update the same cell” (i.e., you wouldn’t put this in the handicap cell itself unless you’re intentionally replacing the original). Best practice is to keep the original handicap column and calculate the adjusted handicap in a separate column.
Hi Jose, thank you for your reaction, this really is helpful especially your additional remarks. Please allow me a few observations.
- When I entered the function, excel did not accept it as a function. Eventually I found out that where you put a kommas, I need to put semicolons. It works now.
- If there are no points entered it should not remain blank but show the last handicap. I tried to correct it, but couldn't. Can you help?
- Can we add to this same function that when a player has >40 points his handicap should go down with 1 point (actual hcp -/- 1.
- Can I add the spreadsheet in this forum?
- Hope I am not abusing with all these questions
Hi, I hope my answer helps you
=IF(A2="";B2; IF(A2<30;B2+1;IF(A2>40;B2-1;B2)))
Hi JoseS, did you read my additional questions?
