| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for spreadsheet, avoiding zeros?
i have a row of formulas.
b11 through h11 b8/b9, c8/c9,d8/d9, so on and so forth. how to i prevent the formula from reporting #DIV/0! when in column B there isn't a number, or the number is 0. In these cases I just want it to be either blank, or a 0, not this error. I know you can't divide by zero, i just don't know how to tell the prog that it doesn't have to, and to just ignore |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Avoiding totals of Duplicate Information | Excel Discussion (Misc queries) | |||
| Avoiding Value error message due to space in cell w/ formula | Excel Discussion (Misc queries) | |||
| What formula is used to replace blanks in spreadsheet with zeros? | Excel Worksheet Functions | |||
| Avoiding typing similar formula 600 times | Excel Worksheet Functions | |||
| Avoiding circular reference on formula | Excel Discussion (Misc queries) | |||
Threaded Mode
