| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
| nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
