G
Guest
I need to be able to delete a number from a cell that ALSO has a formula or
function.
I searched but didn't find what I need. This is the drill...
1.) Example: =IF(B10=127,"$16.00","")
2.) Someone ACCIDENTLY enters XX into the cell
3.) UGHH. They hit delete
4.) =IF(B10=127,"$16.00","") goes BYE, BYE!!
How do I LOCK the formula, but have access to the SAME cell.
function.
I searched but didn't find what I need. This is the drill...
1.) Example: =IF(B10=127,"$16.00","")
2.) Someone ACCIDENTLY enters XX into the cell
3.) UGHH. They hit delete
4.) =IF(B10=127,"$16.00","") goes BYE, BYE!!
How do I LOCK the formula, but have access to the SAME cell.