captcha
11-29-2007, 07:35 AM
Hi all,
I have a circular reference formula that lets me enter a number into a cell (call it A1) and make the value of another cell increase or decrease by that much (call it A2). I've enabled iterative calculations in order to get this to work. There are a series of cells like this. However, I'd like to get A1 to automatically clear itself after a number has been entered and the value of A2 has already been changed by the formula. This is to prevent recalculation of A2 when other cells with circular references are changed in a similar matter. Is there a way to do this, or perhaps a better way to have the value of A2 change by a specified amount?
Thanks in advance for anyone's help!
I have a circular reference formula that lets me enter a number into a cell (call it A1) and make the value of another cell increase or decrease by that much (call it A2). I've enabled iterative calculations in order to get this to work. There are a series of cells like this. However, I'd like to get A1 to automatically clear itself after a number has been entered and the value of A2 has already been changed by the formula. This is to prevent recalculation of A2 when other cells with circular references are changed in a similar matter. Is there a way to do this, or perhaps a better way to have the value of A2 change by a specified amount?
Thanks in advance for anyone's help!