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!

Hi,
Try:
IF(A1="","",A1+5)
Regards - Dave.

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

"Dave" wrote:

Hi,
Try:
IF(A1="","",A1+5)
Regards - Dave.

Thanks for the feedback.
Dave.

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.

"Dave" wrote:

Thanks for the feedback.
Dave.