Question description:
This user has given permission to use the problem statement for this
blog.
Excel formula problem. Trying a autosum function where I am dividing a cell value by 3, but within the same cell want to roundup the answer in the cell to the next whole number even if value is less than 0.5 and more than 0.5
Solved by E. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/10/2018 - 10:56
Hi…Welcome to Got It Pro. I see that your question is about fixing formulas.
Excelchat Expert
05/10/2018 - 10:57
I can help you with that problem.
Excelchat Expert
05/10/2018 - 10:57
Do you have your data to share?
User
05/10/2018 - 10:57
yes
Excelchat Expert
05/10/2018 - 10:58
Please attach the file by using the paperclip icon at the right.
Excelchat Expert
05/10/2018 - 11:00
I can also tell you the formula if you are able to place it correctly on your file.
Excelchat Expert
05/10/2018 - 11:00
You will need to use Round function.
User
05/10/2018 - 11:01
I have loaded a doc
[Uploaded an Excel file]
Excelchat Expert
05/10/2018 - 11:01
=Round(Your formula,0)
Excelchat Expert
05/10/2018 - 11:01
Ok..so column J is where you want the figures rounded, right?
User
05/10/2018 - 11:01
yes
User
05/10/2018 - 11:02
always to be rouded up
Excelchat Expert
05/10/2018 - 11:02
Do you mean 5.4 should say 6 or 5?
User
05/10/2018 - 11:02
even 6.09 as it is based on 3mtr lengths therefore I need 7 lengths not 6
User
05/10/2018 - 11:03
5.4 should be 6
Excelchat Expert
05/10/2018 - 11:03
Ok...got you.
User
05/10/2018 - 11:03
can you see my loaded doc
Excelchat Expert
05/10/2018 - 11:04
Yep...I am working on it.
Excelchat Expert
05/10/2018 - 11:04
I am uploading it back here with the formula.
User
05/10/2018 - 11:04
thx
Excelchat Expert
05/10/2018 - 11:04
[Uploaded an Excel file]
Excelchat Expert
05/10/2018 - 11:05
I have used the formula in column K, which you can move to column J, if you like to.
Excelchat Expert
05/10/2018 - 11:05
Or you can use this...I have done the formula in colulmn J itself.
[Uploaded an Excel file]
Excelchat Expert
05/10/2018 - 11:06
Does that answer your query?
User
05/10/2018 - 11:06
yes but I wanted bothe functions to be in column J answer
Excelchat Expert
05/10/2018 - 11:06
I just uploaded an updated file with the formula in J.
User
05/10/2018 - 11:06
thx perfect
Excelchat Expert
05/10/2018 - 11:07
Is there anything else I can help you with this query?
Excelchat Expert
05/10/2018 - 11:07
Formula used is =ROUNDUP(SUM(H2/3),0)
User
05/10/2018 - 11:07
not at this moment will contact Microsoft website support for any others
Excelchat Expert
05/10/2018 - 11:07
And just drag it down.
Excelchat Expert
05/10/2018 - 11:07
Please feel free to leave any comments or feedback.
Excelchat Expert
05/10/2018 - 11:07
Thanks for your time. Please do come back for any new question. You can now end this session. Have a great day ahead!
User
05/10/2018 - 11:07
if I drag down will it copy for each cell answer
Excelchat Expert
05/10/2018 - 11:07
Yes, it will.
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.