cell contents

B

breeznby

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?
 
P

Per Jessen

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
 
Top