My simple formula referencing the value of another cell is written over by
that value when the value of the referenced cell is changed? This is a
strange question for me to ask because I have been working with excel for
over a decade and have never come across this before