Get instant live expert help on I need help with excel round down formula result

“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

i want to put which formula in excel for total sum value 1552 then it is convert automatic round figure 1552 if result is 1558 then result got 1560
Solved by B. B. in 22 mins
Regard excel round down problem. The cell already uses an IF(ISNA) type formula and I basically want to also add to the formula that if the result is under 100, and is divisible by 10, then it needs to round down by 5, so 30 becomes 25 e.g. In addition to that, if the result is divisible by 100 i.e. 200, 500, 700, then I want it to round down by 5 to e.g. 195, 495 or 695
Solved by S. Q. in 15 mins
I want excel roundup to next whole number with multiple cells containing whole numbers to be rounded to either 5 or 0
Solved by M. H. in 27 mins
How to round in excel with condition. Can I create a rule that says for example $0.50 to $0.99 round up to nearest dollar and $0.01 to $0.29 round down
Solved by I. Y. in 20 mins
Is there a way to do excel round up and down to a set group of quantities?
Solved by K. S. in 26 mins