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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank Cells (or Blanking Cells)
Ted
You probably don't need the =TODAY() formulas..........note, they will change every day, they are not static dates. To find the difference bwtween a static date of Jan 1, 2008 in A1 and today you would enter in B1 =TODAY()-A1 format as General to return 26 As far as making a formula result invisible you have to add a trap. Say you had =TODAY() in A1 You could hide the results of that by adding an IF clause to that A1 formula. =IF(C1="","",TODAY()) which says.........if C1 is blank then show nothing in A1 Otherwise show the date in A1 Gord Dibben MS Excel MVP On Sun, 27 Jan 2008 11:40:05 -0800, Farmer Ted wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank Cells (or Blanking Cells)
Thanks. This helped out a great deal
"Gord Dibben" wrote: Ted You probably don't need the =TODAY() formulas..........note, they will change every day, they are not static dates. To find the difference bwtween a static date of Jan 1, 2008 in A1 and today you would enter in B1 =TODAY()-A1 format as General to return 26 As far as making a formula result invisible you have to add a trap. Say you had =TODAY() in A1 You could hide the results of that by adding an IF clause to that A1 formula. =IF(C1="","",TODAY()) which says.........if C1 is blank then show nothing in A1 Otherwise show the date in A1 Gord Dibben MS Excel MVP On Sun, 27 Jan 2008 11:40:05 -0800, Farmer Ted wrote: 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? |
Reply |
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) |