| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make formula results not show?
Hello,
I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
Put this in B10:
=IF(B9="","",B9+7) then copy down - if B9 is blank, then all the dependent cells will also be blank. Hope this helps. Pete On Apr 18, 10:56*pm, tgcali wrote: Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
You can use if in the formulas
If($B$9="","",B9+7) Then copy and drag that formula down like you did before. "tgcali" wrote: Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
=IF(B9="","",B9+7)
-- Greetings from New Zealand "tgcali" wrote in message ... Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
I appreciate all the tips, but it's still not working. What I get with all
three suggestions is pretty much the same. I enter a date into B9 and B10 on down show 5 digit numbers, not dates. I clear B9 and B10 on down are numbered by 7's. ex. 7, 14, 21, etc. and not blank. Thanks again to all of you who have answered. This is going to drive me out of my skull! "Bill Kuunders" wrote: =IF(B9="","",B9+7) -- Greetings from New Zealand "tgcali" wrote in message ... Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
Ignore that, I figured it out. The formatting for dates had been erased. Your
suggestions were spot on! Thanks! "tgcali" wrote: I appreciate all the tips, but it's still not working. What I get with all three suggestions is pretty much the same. I enter a date into B9 and B10 on down show 5 digit numbers, not dates. I clear B9 and B10 on down are numbered by 7's. ex. 7, 14, 21, etc. and not blank. Thanks again to all of you who have answered. This is going to drive me out of my skull! "Bill Kuunders" wrote: =IF(B9="","",B9+7) -- Greetings from New Zealand "tgcali" wrote in message ... Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
Highlight the cells, go to Format--Cells and change the format to Date.
"tgcali" wrote: I appreciate all the tips, but it's still not working. What I get with all three suggestions is pretty much the same. I enter a date into B9 and B10 on down show 5 digit numbers, not dates. I clear B9 and B10 on down are numbered by 7's. ex. 7, 14, 21, etc. and not blank. Thanks again to all of you who have answered. This is going to drive me out of my skull! "Bill Kuunders" wrote: =IF(B9="","",B9+7) -- Greetings from New Zealand "tgcali" wrote in message ... Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
In order to see the cells B10 on down as dates and not 5 digit numbers, you
have to format the cells as dates. If cell B9 is truly empty and you use the formulas given, there will be nothing in B10 on down It sounds like you're entering a 0 in cell B9, not deleting the contents of the cell to make it empty Tyro "tgcali" wrote in message ... I appreciate all the tips, but it's still not working. What I get with all three suggestions is pretty much the same. I enter a date into B9 and B10 on down show 5 digit numbers, not dates. I clear B9 and B10 on down are numbered by 7's. ex. 7, 14, 21, etc. and not blank. Thanks again to all of you who have answered. This is going to drive me out of my skull! "Bill Kuunders" wrote: =IF(B9="","",B9+7) -- Greetings from New Zealand "tgcali" wrote in message ... Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
Thanks to all of you for your help!
"tgcali" wrote: Hello, I have a summary spreadsheet. I have two columns that require consecutive dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the first date goes in B9, then B10 thru B20 need to autopopulate. I can do this easily by putting =B9+7 in cell B10 and then dragging the handle down the remaining cells. I can lock the cell to keep the formula from being messed up or erased. Cell B9 is the only one that needs to be able to have input. That's all been easy. My problem is that when cell B9 is blank, then B10-B20 continue to display results for the formula. In this case, since it's a date, they display the range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell B9 is blank. Can this be accomplished? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make formula results not show?
You're welcome.
Pete On Apr 18, 11:54*pm, tgcali wrote: Thanks to all of you for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does formula show rather than results (not in text format) | Excel Worksheet Functions | |||
| I can't get my concatenate formula results to show | Excel Discussion (Misc queries) | |||
| Some formula results will not show up in the cell | Excel Worksheet Functions | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Hybrid Mode
