Discussion Locked

Hide Excel Formulas

0 helpful

3 replies

by sakil Apr 16, 2001 last reply Apr 16, 2001

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a spreadsheet that there is a date field to be entered. Another field automatically estimates the due date created by a formula.

This spreadsheet is for very novice users in my organization.

I used the fill handle to copy the formula down the same column of the entire spreadsheet.

How do I hide the formula's automatic answer? The date field is empty, the formula is =sum(a1+14), "due date" is 14 days from the date entered.

When I drag on the fill handle to copy it shows 1/14/00 in every cell because it is calculating the blank date field.

This 1/14/00 entry is confusing my users. How can I hide this answer to the formula until the date is entered into the date field.

Thank you!

3 replies

Try this forula:

=If(IsBlank(A1),"",A1+14)

This will test to see if the cell is empty (blank), and if so will enter an empty string in the cell, otherwise it will put the date calculation.

Hope this helps.

Thank you so much! It worked! I just posted the question and you quickly solved my problem.

Have a great day!

This question was closed by the author

This discussion is closed to new replies.