Thread
:
How do I hide a cell's formula?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Per Jessen
external usenet poster
Posts: 1,533
How do I hide a cell's formula?
Hi
I think this formula is what you want in C2:
=IF(B2="","",B2+120)
Regards,
Per
"Julie A" <Julie
skrev i meddelelsen
...
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)
Reply With Quote
Per Jessen
View Public Profile
Find all posts by Per Jessen