**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula that will increase the numerical value of one cell by a number input in another cell on a daily basis. For eg: If A1 is 100 and the daily input cell B2 is 3, A1 should change to 103. Tomorrow if B2 is changed to 6, A1 should change to 109.

Solved by Z. F. in 25 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
24/02/2018 - 07:28

Hello! Welcome to Got It Pro-Excel.

User
24/02/2018 - 07:29

Thank you, hope you can help

Excelchat Expert
24/02/2018 - 07:29

Sure

Excelchat Expert
24/02/2018 - 07:29

I'm so glad to assist you at this part

Excelchat Expert
24/02/2018 - 07:31

I will work at this problem now, and send the resulting file with you when done. Will this be fine with you?

User
24/02/2018 - 07:32

Yes that's fine. The formula I'm trying to input comes up with a circular reference error

Excelchat Expert
24/02/2018 - 07:34

Yes, got it. But Circular reference error can be resolved by enabling the iterinary setu.

Excelchat Expert
24/02/2018 - 07:34

lease hold on, I will show you how when done

User
24/02/2018 - 07:35

tried that too but it comes up with a wiered number

User
24/02/2018 - 07:35

ok

Excelchat Expert
24/02/2018 - 07:37

Yeah, got it

Excelchat Expert
24/02/2018 - 07:37

Please let me check,

User
24/02/2018 - 07:38

that was quick

Excelchat Expert
24/02/2018 - 07:41

Please check on this file, as shown at your A1

[Uploaded an Excel file]

Excelchat Expert
24/02/2018 - 07:41

Try to change the value at B2 for testing the result

User
24/02/2018 - 07:43

I'm trying that but the value of A1 remains the same

Excelchat Expert
24/02/2018 - 07:44

To resolve the circular reference, please set your file as shown on the screenshot

[Uploaded an Excel file]

User
24/02/2018 - 07:45

I've done that and I change the value on B2 to 50, A1 changed to 5733

Excelchat Expert
24/02/2018 - 07:45

From File menu, click on "Options", then Select formula, then check the boc at "Enable iterative circulation"

Excelchat Expert
24/02/2018 - 07:46

Okay, to clean it up, first put 100 only at your A1

User
24/02/2018 - 07:46

ok

Excelchat Expert
24/02/2018 - 07:46

After putting the number, copy this formula at A1 to replace the number =SUM(A1,B2)

Excelchat Expert
24/02/2018 - 07:47

Then try to change the value of B2, for testing

User
24/02/2018 - 07:48

I did the above and still had 50 on B2. When I hit enter after the formula A1 changed from 100 to 5000

User
24/02/2018 - 07:48

I changed B2 to 10 and A1 changed to 6000

Excelchat Expert
24/02/2018 - 07:49

Okay, please set the "Maximum iterations" into 1, then maximum change into 0.001

Excelchat Expert
24/02/2018 - 07:49

Please refer at the screenshot shown encircled with blue color

User
24/02/2018 - 07:50

ok perfect it works

Excelchat Expert
24/02/2018 - 07:50

Great, you got it :)

User
24/02/2018 - 07:50

Thank you

Excelchat Expert
24/02/2018 - 07:50

My pleasure

User
24/02/2018 - 07:50

This is a great help

Excelchat Expert
24/02/2018 - 07:51

Yeah, its the best solution ever, I'm sure you'll never forget the technique

User
24/02/2018 - 07:52

For sure.

User
24/02/2018 - 07:52

Thanks again, now back to work

Excelchat Expert
24/02/2018 - 07:52

Okay, any more concern with this circular reference?

Excelchat Expert
24/02/2018 - 07:52

Oh sure

Excelchat Expert
24/02/2018 - 07:52

Thank you for coming at Got It Pro-Excel!

Excelchat Expert
24/02/2018 - 07:53

For any other Excel issues, please don't hesitate to come again. We will be glad to support you anytime.

User
24/02/2018 - 07:53

I'm glad I found this. I've been trying for almost 7 hours

User
24/02/2018 - 07:53

Sure

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*