# Get instant live expert help on roundup excel to nearest 5

“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 need a formula to divide a dollar amount by a number of months and then roundup the answer to the nearest dollar.
Solved by V. J. in 21 mins
DEAR EXPERT, I WOULD TO "ROUNDUP", TO "THE NEAREST HUNDRED" THE ANSWER TO "2000-1820 = 180", I WOULD TO DISPLAY "200" FOR THE ANAWER. THE SAME "200" FOR "2000-110". THANK YOU, JIM
Solved by K. Q. in 11 mins
Hello, I have times in cells and I need to do some disproportionate rounding. I need to round the minutes as follows: 12:51 to 13:05 rounds to nearest qtr interval of 13:00 13:06 to 13:20 rounds to nearest qtr interval of 13:15 12:21 to 13:35 rounds to nearest qtr interval of 13:30 12:36 to 13:50 rounds to nearest qtr interval of 13:45 13:51 to 14:05 rounds to nearest qtr interval of 14:00 And so on. I can't get my head around this at all!
Solved by Z. Q. in 30 mins
need to plot neighbourhood for matrix in my excel sheet with nearest value max 1 min 0
Solved by G. Q. in 17 mins
=If(Sheet1!B3>7, IF(MOD(Sheet1!B3/6)<QUOTIENT(Sheet1!B3/6), Roundup(Sheet1!B3/6,0),Rounddown(Sheet1!B3/6,0)),1) This returns a "1" as expected for values 7 or less, but an error for all values 7 or greater. I want it to return a 1 if the value is not greater than 7, and if it is greater than 7 I want it to evaluate whether the remainder of the value divided by 6 is less than the quotient for the value divided by 6. If it is, I want it to round up the value divided by 6 to the nearest ones place digit. Otherwise, I want it to return the value divided by 6, rounded down to the nearest ones digit.
Solved by A. A. in 28 mins