Forum Discussion
Excel "IF" function
I'm creating a spreadsheet for my golf club. We have special rules. One of them is that if a player has fewer than 30 Stableford points after a round, their handicap increases by 1 point. Can I do t...
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)))