Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank Cells (or Blanking Cells)
I have made an excel spreadsheet and it is looking real nice. However, I was
wondering, How do I stp a formula from appearing if I do not want it to appear unless there is a contents in the cells that will generate it. I have two columns that have formulas in them but I do not want the formula (or data) to show unless there is data in that row. The two formulas are = Today () - I only want this to show when something is place in that row. As it is it goes all the way down the page. How do I fix this. The other formula is a calculation of that box vs the date input in a prior Cell (i.e. what the difference in those days are [ 45 day difference, 20 day difference etc] Any help with this. . .or where I can look? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Formula Help: Add cells with certain text + cells that are blank | Excel Worksheet Functions | |||
how can i ignore blank cells when multiple cells? | Excel Worksheet Functions | |||
Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) |