I have done a simple formula to average 4 test scores which equals 3. The average score of 3 would be the equivalent of a golf handicap of 25. How to I create a formula which I can use to convert a score to an equivalent handicap score. I made this one but it doesn't work IF('3/4 WEDGE SHOT' AVERAGES=3,25,0)
Solved by I. Y. in 16 mins