 # Get instant live Excel expert help to learn how to round a number in Excel “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

To few arguments on a solution =ROUND(SUM(B4:B10)/7);2 I don't know what's wrong. I want to round the solution to two decimals.
Solved by B. C. in 27 mins
Several questions on Round formulas, SumIf, etc using the raw data set on the second tab
Solved by A. W. in 13 mins
IF(B8<=12600,0,IF(B8>=12400,0,IF((B8>12600<12400,((ROUND(C8*((B8/12600)),2)-C8)*A8))
Solved by D. H. in 30 mins
I want to rround off function in excel my numbers to 3 decimal places
Solved by D. L. in 20 mins
I'm using this formula in my spreadsheet but I would also like it to round to the nearest quarter and have the output end in 9. =ROUND(E20*(1+D20),0)-0.01
Solved by D. S. in 25 mins
I need a formula that adds a 1 for every 66. So if the sum is 66 meter means I need to buy 1 tape. If the sum is 132 meters means I need to buy 2 tape and so forth. It also needs to round up. so if the final result is 129, then it rounds up to 132 and tells me to buy 2
Solved by D. D. in 29 mins
I got this mround excel formula from help here =MROUND(C55,5). It works, but I just released that when the sum of c55 is 2.5, it rounds down to 0. I need it to round up to 5.
Solved by M. U. in 24 mins