not sure what you mean by "when the data is cleared?" The formula will stay
there until it is erased. To keep it from being erased, do a
Format/Protection/Locked, then do a tools/protection/protect sheet

"CMZ" wrote:

How do I maintain a formula in a cell when the data is cleared? I thought by
creating a templet the problem would be resolved, but I am not having any
luck. Any ideas??