How do I conditionally disable a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=if(iserror(average(A1:A?),"No data",average(A1:A?)
The iserror function returns a TRUE or a FALSE. If true enter nodata in
cell, if false do the average.

Gilles
 
Good call Gilles. Merci Beaucoup!

Gilles Desjardins said:
=if(iserror(average(A1:A?),"No data",average(A1:A?)
The iserror function returns a TRUE or a FALSE. If true enter nodata in
cell, if false do the average.

Gilles
Click to expand...
 
Back
Top