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 ...
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.