Forum Discussion
Replacing values in a cell that is part of a Formula
I have just a basic knowledge of what Excel can do so I don't even know if this is possible.
I'd like to use the value in a cell as part of the formula in another cell, then replace the value in the original cell with the result of the formula without causing a circular reference.
For example:
A
1 - 100
2 - 25
Is it possible to add cells A1+A2 and replace the value in A1 with the result - i.e. A1 would then be 125.
2 Replies
You could do the following, but I wouldn't recommend it.
Select File > Options.
Select Formulas in the navigation pane.
Tick the check box 'Enable iterative calculation'.
Set 'Maximum iterations' to 1.
Click OK.
Enter the formula =A1+A2 in A1.
The initial value of A1 will be 0.
Each time you enter a value in A2, it will be added to the displayed value in A1.
- Thank you Hans. I appreciate you taking the time to answer. I will keep that suggestion in consideration.
