ExcelBanter - Keeping Formulas Not Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Keeping Formulas Not Data (https://www.excelbanter.com/excel-worksheet-functions/265284-keeping-formulas-not-data.html)

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

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