| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 ????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
