| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returning a blank cell if answer is zero
On Dec 17, 12:47*am, Rich wrote:
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, =IF(Formula=0,"",Formula) |
| Reply |
| 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) | |||
Hybrid Mode
