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

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

need to plot neighbourhood for matrix in my excel sheet with nearest value max 1 min 0

Solved by G. Q. in 17 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

In cell A1 I have 1000, in A2 1000-995,in A3 1000-995-900 and so on till 1000 rows

Solved by O. J. in 15 mins