| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyway to hide #DIV/0! in an excel worksheet cell.
I am not aware of an elegant way but I know of two work-arounds.
Option 1. Apply conditional formatting to the cell by selecting "Formula Is" and typing "=ISERROR(A1)" where A1 represents the current cell. Format the cell to use the white font color (or whatever color your sheet's background is) when the condition is met. Option 2. Trap for the error in the formula itself, such as "=IF(ISERROR(A1/B1),0,A1/B1)". You can then apply your custom format that hides zero values. Both options add quite a bit of overhead to the file, so I would not recommend using them often in heavy duty financial model or the like. HTH Kid Jones "rlugood" wrote: I learned how to hide a zero by entering in 0;-0;;@ in the custom format area. I would like to know if there is anyway to hide #DIV/0! until a valid number is calculated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you hide a tab for a single worksheet in Excel? | Excel Discussion (Misc queries) | |||
| is there a way to hide a whole worksheet in excel? | Excel Discussion (Misc queries) | |||
| How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
| Excel VBA-hide row worksheet event | Excel Programming | |||
Threaded Mode
