How do I conditionally disable a formula?
I'm doing up golf handicap calculator in Excel and I need to include even par
rounds in the averaging. I also need to un-include cells which contain no
value (0) (as when I have not entered a slope rating) so that they do not
return a #DIV/0! or #VALUE! and disallow the averaging formula from working
in the process. Anyone?
|