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
I WANT FIX FORMULA ERROR PLEASE HELP ME FOR ROUND DOWN AND ROUNDUP FUNCTION.
Solved by I. A. in 16 mins
I have this problem with excel round to nearest. I need to use birth date in one column and date of entry into program in another and round to the nearest tenth decimal
Solved by T. Q. in 18 mins
Hello, How do you set up an automatic rule or formula so that if a calculation has an answer of a set value, that it will automatically excel round up or down to the next unit of "5". For example, if the calculation answer is "91 lbs" it would round down to 90. If it said "93 lbs" it would round up to 95?
Solved by A. A. in 23 mins