I am setting up a simple golf scorecard and assigning "points" to pars,
birdies, etc. in an effort to pair players in a partnership competition based
on recent performance. One of the functions to assign points is
=IF(B3=4,"2",IF(B3=3,"3",IF(B3=2,"4",IF(B3=5,"1",I F(B35,"0"))))). I want to
total the points assigned for each hole but I am unable to do so with the SUM
function, it just returns "0". I read in the "Help" somewhere that it ignores
values returned from functions. Is there a way to override this and get the
function to read the values? I have never built a Macro but would that be a
solution? I want to retain the worksheet as a template so I would like to be
able to have it perform the functions without rebuilding the worksheet.
Thanks for any suggestions.
Duff Divot