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.
