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?

$DB$4242 ?

Regards,
Per

"thinatlanta" skrev i meddelelsen
...
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?