returning blank when reference cell is blank

M

mslylan2u

I think there should be a simple solution to this, but I can't seem to find
the answer. I'm creating an order follow-up log where there are columns that
specify to follow up in a set number of days, based on order entry date. I
have copied the formula for 200 rows, but it returns "01/05/00" (for 5 days
after date of entry) when there is no entry in the referenced cell. (I
understand why) How can I make the cell return nothing (blank) when the
referenced cell is blank (no entry?)

Example:

Date of Order
Cell A1
Entry is 06/06/08

Follow up
Cell M1
Formula is =A1+5
Returns 06/11/08

When A1 is blank, formula returns 01/05/00
I would like it to return nothing.

Thank you!
 
M

mslylan2u

Thank you very much! I looked at the IF function, but just couldn't quite
get there.
 
M

mslylan2u

Another question if you don't mind - I'm going to share this log that some
may print out. I noticed when doing a print preview, that all the "blank"
rows show up to print. Without having to change the print area, how do I
specify to only print where there are values in the rows? (we have people
who get trigger happy and waste paper and also are not versed in the Print
Area feature)

Thanks.
 

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

Workday Formula to include date 0
Date/Time 1
Modifying a complex date formual to count months 4
formatting 2
Comparison of columns using Conditional Formatting 3
Finding the date in a table when one value first exceeds another. 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Identifying non-returning formula (blank Cell) 9

Top