| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I hide a cell's formula?
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a referenced cell's formula instead of formula output? | Excel Worksheet Functions | |||
| How do I use a cell's text, "A1", and put it in a formula? | Excel Worksheet Functions | |||
| Formula that will allow you to add one to cell's value by clickin. | Excel Worksheet Functions | |||
| Hide a row based on one cell's condition | Excel Worksheet Functions | |||
| Setting a cell's formula with VBA | Excel Programming | |||
Linear Mode
