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
Can you share your sheets please?
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.