How to make formula results not show?

T

tgcali

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?
 
P

Pete_UK

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
 
A

akphidelt

You can use if in the formulas

If($B$9="","",B9+7)

Then copy and drag that formula down like you did before.
 
T

tgcali

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!
 
T

tgcali

Ignore that, I figured it out. The formatting for dates had been erased. Your
suggestions were spot on! Thanks!
 
T

Tyro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
sum to recognize new rows 3
How do I keep the divisor constant in calculating percentage remai 3
I hate the DIV/0! error! Can anyone help me make this go away? 5
Auto populate date VBA code 7
Eliminating "#VALUE!" for a formula’s results 1
How do I find data excluded from a list in excel? 2
Payment calculation 1

Top