| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I conditionally disable a formula?
=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 "BB" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I conditionally disable a formula?
Good call Gilles. Merci Beaucoup!
"Gilles Desjardins" wrote: =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 "BB" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I conditionally disable a formula?
Pleased to help.
Gilles "BB" wrote in message ... Good call Gilles. Merci Beaucoup! "Gilles Desjardins" wrote: =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 "BB" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| how do I disable the formula bar? | Excel Discussion (Misc queries) | |||
Hybrid Mode
