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
|