Get instant live expert help on I need help with excel roundup 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