How do I hide a cell's formula?

  • Thread starter Thread starter Julie A
  • Start date Start date
J

Julie A

I would like to hide the formula in a spreadsheet I am working on. Below is
an example of why. When someone enters the intake date, i want it to add 120
days to give them the 4 month interview date. But, I don't want the formula
in column c to show until B is entered

B C
Intake Date Anticipated 4 month interview date
3/25/2009 7/23/2009 (B2+120)
 
Hi

I think this formula is what you want in C2:

=IF(B2="","",B2+120)

Regards,
Per
 
Back
Top