I'm not quite sure of the terminology involved in this problem. What I have to do is calculate in column B some values dependent on the current contents of column A. This I do with a formula as there are a lot of rows (the formula is
=90 - A1).
Then, given this new value in column B, to set the value in column A to the new value of column B (using
=B1). This gives me zero in all cases (rather than the circular reference I was expecting).
What I'd like to do is fix the current value of column B as it has been calculated, so I can then set the value of column A as I like. Is there any way to do this?
Edit: the values must end up in columns A and B, although I can scribble in any other column as necessary.