Good solution.

Thanks for the feedback.


Gord

On Sat, 3 Nov 2007 15:47:01 -0700, Margo
wrote:

Thank you. And after trying it anyway, I am heeding the warning.

Since I obviously have a lot to learn yet about formulas/functions I've
created a solution by 'Hide' the column with the original values after they
have been entered, my formulas then work well, and the column with the
correct and updated value is the only one showing. And 'Unhide' allows input
checking if necessary.

"Gord Dibben" wrote:

To add to Niek's "strong advice".

Doing it as you describe will leave no "paper trail" of inputs so very difficult
to troubleshoot any errors in data entry.

Excel has lots of cells, use them to keep track of your inputs.


Gord Dibben MS Excel MVP

On Sat, 3 Nov 2007 21:42:28 +0100, "Niek Otten" wrote:

<guess I'm going to go take a Visual Basic course

You could, of course.

But what remains is that circular references and similar concepts should not be used, unless it is the very nature of the problem
description itself, like for some recursive calculation algorithms.
For record-keeping structures, like the one you describe, I strongly advise NOT to use circular references.