Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Trusted by people who work at