Replacing values in a cell that is part of a Formula

New Contributor

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

@Jim_C0256365 

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.

S1284.png

Thank you Hans. I appreciate you taking the time to answer. I will keep that suggestion in consideration.