| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hide Value of Cell
Hello,
I have a cell (c) with this formula: =(a2/b2)-1.005. I want to hide the #DIV/0! that appears in the cell when there is no data in a2 or b2. Is this possible? Thanks in advance for your help. Mark |
|
#2
|
|||
|
|||
|
Try:
=IF(B2<0,(A2/B2)-1.005,"") Art "Mark" wrote: Hello, I have a cell (c) with this formula: =(a2/b2)-1.005. I want to hide the #DIV/0! that appears in the cell when there is no data in a2 or b2. Is this possible? Thanks in advance for your help. Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
| Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
Linear Mode
