enter image description heream hoping someone can help create a formula for the following scenario in my golf stats I want cell c5 to be 0 or 1 for the following: c1 is the par of the hole which is 4 c2 is my score for the hole which is 5 c3 is the number of putts for the hole which was 2
In c5 I wish to calculate the strokes I took from c2 (5) and subtract the number of putts from c3 (2). This would then become the no. of strokes I took to reach the green (GIR) (called green in regulation) and if this figure is 3 or anything less than 3 and the par is (4) in c1 AND I receive a shot on this hole according to my handicap, then c5 would show 1. Any value more than 4 in c5 would mean that I did not reached green in regulation then would show as 0.
Does a excel formula exist for calculating this
81 Answer
I am still not 100% sure I understand your full question but I will give you an answer which answers what I think you need.
Given the above example, the formula in Cell C5 is =IF((C2-C3)<C1;1;0)This subtracts the number of puts you have from your total score for the hole, if it is less than the par of the hole then you should have reached the GIR and the result will be 1. If the puts minus your score is higher than the par of the hole then you did not reach GIR and you get a 0 here.
If you want to add a condition where you only get GIR if you did actually hit the Green in Regulation AND you scored points for that hole (not a requirement for GIR, you can hit the green off the tee on a par 4 and score GIR but still need 8 putts and hence not score any points for the hole, but...) then, assuming your handicapped score is in Cell C4, change the formula too =IF((C2-C3)<C1;IF(C4>0;1;0))
I hope this helps.
2
