clearing a cell

G

genevieveg

I'm very new at using excel and if someone could help me please:) :) how
do I keep a formula in a cell example I've put the formula in the cell
and go back to it to enter some data and need to clear the data I
always seem to clear my formula what do I do????to keep the formula in
the cell Thanks gg
 
A

Alan

Formulas cant work in the cell they occupy, nor can a formula change the
contents of a cell it occupies. Say in A1 there was the formula:
=B1+C1
then A1 will display the sum of B1 and C1,
If you go back to A1 and enter something else, the formula is gone,
Regards,
Alan.
 
Top