# Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 05/10/2018 - 11:01
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
User 05/10/2018 - 11:04
thx
Excelchat Expert 05/10/2018 - 11:04
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.
Excelchat Expert 05/10/2018 - 11:06
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
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
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.

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.