cell contents
 

I have formatted a range of cells with a formula. It's an expense worksheet
that keeps a running total among other things. The last result is repeated
until I enter new data. How can I delete the contents of the cells not yet
used without deleting the formula itself?
--
breeznby

cell contents
 

Hi

You have to use an if formula like this:

=if(A1="","",A1*2)

If A1 is empty, the formula cell will remain empty, else calculate the
formula.

Hopes it helps.

Regards,
Per

On 7 Dec., 19:27, breeznby wrote:
I have formatted a range of cells with a formula. *It's an expense worksheet
that keeps a running total among other things. *The last result is repeated
until I enter new data. *How can I delete the contents of the cells not yet
used without deleting the formula itself?
--
breeznby