| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing zero in cell
Hi
Could you tell me how to get zero or blank with this formula:- =(V4-U4) both columns are dates but if there is no date in column V4 then it shows -38694 could you tell me what formula I need to put in to make this show as zero or blank if there is no date in V4. Thanks -- Clare |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop cell showing zero when returning a blank cell | Excel Discussion (Misc queries) | |||
| showing an empty cell instead of a zero in a formulated cell. | Excel Worksheet Functions | |||
| Showing Last value in a cell | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Showing the contents of a cell based on another cell | Excel Worksheet Functions | |||
Threaded Mode
