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.
"genevieveg" wrote
in message ...

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


--
genevieveg
------------------------------------------------------------------------
genevieveg's Profile:
http://www.excelforum.com/member.php...o&userid=30333
View this thread: http://www.excelforum.com/showthread...hreadid=499991