| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Zeros look like no entry
I have a spreadsheet that makes some calculation in a column, based on
multiplying numbers entered in 2 other columns. However, for some of the rows, there is no "input" data, and so the calculation simply indicates the answer is zero. This gives me a column with lots of zero's in the cells. I'd prefer there simply to be a blank cell, whenever the result of the formula is zero. Is there a way to achieve that? Thanks much. ddc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making the AND function look at only part of a cell entry | Excel Discussion (Misc queries) | |||
| how do you store real time in excel when making an entry | Excel Worksheet Functions | |||
| automatically prefix cell entry with leading zeros | Excel Worksheet Functions | |||
| How to program data entry to avoid zeros or last 5 digit. | Excel Discussion (Misc queries) | |||
| Making Cell Entry Mandatory | Excel Discussion (Misc queries) | |||
Threaded Mode
