| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding error message when dividing by 0
I have a formula calling for an average in a workbook that refers to a cell
group that is sometimes not used. To keep the cells from averaging, I insert an X. That works fine, but when ALL the cells are X I get that irritating "You are trying to divide something by 0" message. I understand that and just don't want it to show up in the cell. Can't think of a way. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
| Why do I get an error message hiding excel columns | Excel Worksheet Functions | |||
| hiding columns in Excell error message | Excel Discussion (Misc queries) | |||
| Hiding error message | Excel Worksheet Functions | |||
| hiding error message | Excel Worksheet Functions | |||
Threaded Mode
