If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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!! |
Thread Tools | |
Display Modes | |
|
|