# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Recently Excel stopped recognizing when I'd change a value in a formula. For example, I'd have five numbers summed in a formula... 1+2+3+4+5=15. If I change any of the inputs, for example changing 1 to 0, thus 0+2+3+4+5, it still equals 15, unless I go in and edit the formula. Help!
Solved by C. J. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/08/2018 - 03:25
Hello
Excelchat Expert 29/08/2018 - 03:25
How are you today?
User 29/08/2018 - 03:25
Hi
User 29/08/2018 - 03:25
Good and you?
Excelchat Expert 29/08/2018 - 03:25
I am great, thank you!
Excelchat Expert 29/08/2018 - 03:25
Excelchat Expert 29/08/2018 - 03:26
Here is what we need to do.
Excelchat Expert 29/08/2018 - 03:26
1. On the ribbon - go to Formulas
User 29/08/2018 - 03:26
OK
Excelchat Expert 29/08/2018 - 03:26
2. Under the Calculation - Select Calculation Option
Excelchat Expert 29/08/2018 - 03:27
3. Select Automatic
Excelchat Expert 29/08/2018 - 03:27
and then check if formula works
User 29/08/2018 - 03:28
Just a sec
Excelchat Expert 29/08/2018 - 03:28
Sure
User 29/08/2018 - 03:30
That seems to work. I don't know why it changes, I didn't make any changes to the setting.
User 29/08/2018 - 03:30
Regardless, thank you!
Excelchat Expert 29/08/2018 - 03:30
The pleasure is all mine
Excelchat Expert 29/08/2018 - 03:30
Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side and requesting you to provide good feedback and review so that I can continue my services to others.
User 29/08/2018 - 03:30
You bet!

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.