ExcelBanter - Formulas in Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formulas in Cells (https://www.excelbanter.com/excel-discussion-misc-queries/142682-formulas-cells.html)

Sheryl[_2_]

Formulas in Cells

How do I clear the numbers in the cells but keep the formulas?

AKphidelt

Formulas in Cells

That doesn't make sense. To clear the numbers in a formula you would clear
the numers the formula is referring to. Or is there something else you're
trying to do?

"Sheryl" wrote:

How do I clear the numbers in the cells but keep the formulas?

Dave Peterson

Formulas in Cells

Maybe you can adjust your formula so that the cell looks empty under certain
conditions:

=if(a1<10,"",yourformulahere)

(for example)

Sheryl wrote:

How do I clear the numbers in the cells but keep the formulas?

--

Dave Peterson

Gord Dibben

Formulas in Cells

Maybe F5SpecialConstants?

Check/uncheck the options and OK.

EditDelete.

Formulas will remain untouched.

Gord Dibben MS Excel MVP

On Mon, 14 May 2007 11:05:02 -0700, Sheryl
wrote:

How do I clear the numbers in the cells but keep the formulas?

All times are GMT +1. The time now is 08:42 PM.