View Single Post
  #1   Report Post  
sh-boom
 
Posts: n/a
Default how prevent formula in cell from deleting when deleting value????

example: =sum(a1-b1-c1) answer and formula in cell d1
if i delete the answer to this formula in cell d1 it also deletes
the formula. i want the formula to stay in the cell d1
how can formula be locked or protected in cell d1 and still make
and delete value entries in cell d1 ?????