Keeping Formulas Not Data

  • Thread starter Thread starter Jenni R
  • Start date Start date
J

Jenni R

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!!
 
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
 
Back
Top