Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a smarter way to do this?
In order to avoid the unsightly #Div/0! appearing in printouts, where I do a divide, I almost always do this: =if(isnumber(A1/B1),A1/B1,"--") Is there a way to tell excel to always show a specific value (in my case "--") whenever a #Div/0! shows up, so that I don't have to handle the exceptions in the cell formulae myself? The example above is really too simple. Often the division are built from much more complicated calculations which can make the whole if statement a 200 letters long. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Handling Errors When Opening Word Docs From Excel VBA | Excel Programming | |||
Handling Errors with Workbooks.OpenText | Excel Programming | |||
Handling Errors and MessageBox | Excel Programming | |||
Handling errors in formulas (how annoying are they!) | Excel Discussion (Misc queries) | |||
Handling Errors from Worksheet Functions | Excel Programming |