I have a schedule where I need to compare two columns. I use and "if"
function right now =IF($A4242-$DB4242=0,0,$A4242) It gives me the line number
where the error occurred. This formula works well if a line is copied down
incorrectly but if someone cuts a line out and pastes it, the formula loses
track of the value DB4242 (because it's gone) and I get "ref". Is there a way
to keep the value of DB4242?