Keeping Formulas Not Data

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Errors for formulas 3
E2007 formulas display as formulas, not results 3
Possible to refer to a sheet's object name ? 1
delete data -not formula 3
Excel Help to copy information from one row at a time to another sheet 1
How do i add a function button to a worksheet? 3
How to copy & paste a worksheet but change 1 bit of the formula? 1
Time Sheet Summary 1

Top