| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returning a blank cell if answer is zero
In Excel 2003, I have a worksheet that has formulae in a column. If the
result is zero, it displays a zero. I copied the column to another worksheet and on that worksheet, if the result is zero, the cell is blank. Where is the switch to have it show zero or show blank? I'm quite sure it exists...I just don't know where. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning blank when reference cell is blank | Excel Worksheet Functions | |||
| Formula returning wrong answer | Excel Worksheet Functions | |||
| Formula returning wrong answer | Excel Worksheet Functions | |||
| Formula returning wrong answer | Excel Worksheet Functions | |||
| IF Formula and blank answer | Excel Discussion (Misc queries) | |||
Threaded Mode
