cell protection
Posted by gail g on August 07, 2001 10:52 AM
Is it possible to protect a cell so that when a "sort data" is done, the cell retains the same formula (which refers to a specific cell value) without changing it to reflect the move?
Posted by Cory on August 07, 2001 2:07 PM
You can't protect a cell and get that result, but you can protect the formula by making the cell references absolute ($A$1). Ex:
=if(sum(A1:A15)*B21)>C35,"",sum(A1:A15)*B21)
has no absolute references
=if(sum($A$1:$A$15)*$B$21)>$C$35,"",sum($A$1:$A$15)*$B$21)
has all cell references as absolute
The $ signs in front of the column and row values keeps the formula from increasing or decreasing when you copy them or move them.
Hope that's what you're looking for...
Cory
