How can I prevent loosing formula during data entry?

[Guest]

I have a work book that has data containing formulas. while editing the
same , on some cells, it was found that the formula is getting lost during
data entry....Can some one help me on this please......

 

[Max]

A cell can only contain either data (input) or a formula, not both.

You should normally enter the data where the formula points to, e.g.: if the
formula in C1 is: =SUM(A1:B1),
then data (i.e. numbers) could be entered into A1 and B1, and C1 will then
compute the total ..

 

[Guest]

if the data is being entered in the wrong cell, You should concider
protecting cells except those available for data entry.

Being a klutz, I do this even on stuff I do only for myself.