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?

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?

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?

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?

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?

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?

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?

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?

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?

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!