# Excel - IF Function Problem - Expert Solution

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

Every 40 add 1. This is what I need excel to do. If the cell input is 80 the total in the other cell should show 2... and so on (endless). For example, if B4 has an input of 40 B3 should show 1, if B4 has an input of 41-80 B3 should show 2, if B4 has an input of 81-120 B3 should show 3
Solved by A. Y. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/08/2018 - 07:07
Greetings! Thank you for choosing Got It Pro!
Excelchat Expert 15/08/2018 - 07:07
User 15/08/2018 - 07:08
Here it is
Excelchat Expert 15/08/2018 - 07:08
Okay. Where do you want the formula to be?
User 15/08/2018 - 07:08
So its the value in B3 that I want to be changed based on the value in b4
Excelchat Expert 15/08/2018 - 07:08
Okay. Hold on.
Excelchat Expert 15/08/2018 - 07:11
There you go.
Excelchat Expert 15/08/2018 - 07:11
You can double check by changing the value in B4.
User 15/08/2018 - 07:12
WOW
Excelchat Expert 15/08/2018 - 07:12
Working perfectly, right?
User 15/08/2018 - 07:12
I could have saved myself 5 hours of trial and error lol
User 15/08/2018 - 07:12
yes
Excelchat Expert 15/08/2018 - 07:12
Great! It's worth trying, that's fine.
Excelchat Expert 15/08/2018 - 07:12
At least now you know that we're here to help you out :)
Excelchat Expert 15/08/2018 - 07:13
In any case, I'll mark this now as answered.
User 15/08/2018 - 07:13
Yes! life saver
Excelchat Expert 15/08/2018 - 07:13
I am but a humble person helping you with your problems. You are most kind.
User 15/08/2018 - 07:13
Yes for sure. Thanks for your help. Now I know where to go to find help
Excelchat Expert 15/08/2018 - 07:13
You may end the chat session now. Once you do, please consider leaving a feedback or comment! That will help us know how we did today.
Excelchat Expert 15/08/2018 - 07:13
I am glad to hear that! Looking forward to helping you once again! :)
User 15/08/2018 - 07:14
I will. Thank you.
Excelchat Expert 15/08/2018 - 07:14
Have a great day, friend!

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.