| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping Formulas Not Data
I input my formula, but would like to fill in the data later. How do I save
the Formula without there being data. I am trying to create time sheet that will be filled out weekly so the data will change. I want the formulas to add hours etc. to be in the worksheet with or without the data. Help!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keeping Formulas Not Data
You don't need data in order to have formulas.
What is the real question here? Do you want the cells with formulas to look blank until data is entered? I suggest you trap for no data. In B1 enter =IF(A1="","",A1) will return a blank cell until data is entered in A1 Gord Dibben MS Excel MVP On Fri, 4 Jun 2010 16:21:23 -0700, Jenni R wrote: I input my formula, but would like to fill in the data later. How do I save the Formula without there being data. I am trying to create time sheet that will be filled out weekly so the data will change. I want the formulas to add hours etc. to be in the worksheet with or without the data. Help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPY WORKBOOK KEEPING FORMULAS AND TEMPLATES, BUT LOSING THE DATA | Excel Discussion (Misc queries) | |||
| Copying Workbooks and keeping the formulas only? | Excel Discussion (Misc queries) | |||
| Keeping formulas that reference a tab that changes daily? | Excel Worksheet Functions | |||
| adding new rows and keeping the same formulas | Excel Worksheet Functions | |||
| Help with keeping formulas in place! | Excel Discussion (Misc queries) | |||
Linear Mode
