“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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