| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
I have fixed an excel document with a formula to figure dates, but if I don't
put a figure in the cell that it refers to, there is a date where the formula is and I don't want a date there unless I put a date in the cell the formula references. How do I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
I have fixed an excel document with a formula to figure dates, but if
I don't put a figure in the cell that it refers to, there is a date where the formula is and I don't want a date there unless I put a date in the cell the formula references. How do I do that? On way is to use a formula something like: =IF(A1="","",your_formula_here) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
