Hide formula result values until all components are entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with a formula to calculate a date based on a date entered in
the previous column. I want the result in the column to be blank until the
date is entered. Now it reads 01/01/00 until I enter a date for it to
calculate correctly. Please help!
 
You have to trap the error, or date in this case, but it's impossible to tell
you how to do that without you giving us the formula.

Dave
 
Maria said:
I have a column with a formula to calculate a date based on a date
entered in the previous column. I want the result in the column to
be blank until the date is entered. Now it reads 01/01/00 until I
enter a date for it to calculate correctly. Please help!
Click to expand...


Hi Maria,

I think you could try something like this:

=IF(AND(A2<>"",A2<>0),your_formula,"")

where A2 is the cell where to input the date to calculate. Adapt references
as for your conveniences.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
01/01/00 indicates 0 in a date formatted cell. Why can't you try this:

Tools - options - view - uncheck zero values

Regards,

Jaleel
 
Back
Top