Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am curently writing a spreadsheet and i have formulae in this sheet where
sometimes i expect to have the #div/0 error but my problem is i have other formulae that use cells containing the #div/0 error so my question is how can i make a cell show a 0 instead of the #div/0 error so it won't effect other formulae. any help on this topic would be very very much appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#DIV/0 error | Excel Discussion (Misc queries) | |||
Need help with dividing and using ISERROR for Div/0! | Excel Worksheet Functions | |||
Chart - date with errors #DIV/0! | Charts and Charting in Excel | |||
how to remove #DIV/0! | Excel Worksheet Functions | |||
How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) |