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

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

i need to know how to make each cell convert to twice that number rounded to the nearest dollar that is a ninth for example i need 787.95 to convert to 1579, also i need one more other formula to be put into place i need the 787 to just have the 95 cents taken off the number please show me these two formulas

Solved by Z. J. in 22 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

Using a formula that gives an answer that rounded up. However I need the answer rounded up and down. I have the formula set up for it, i just need to put the answer in a different cell and have it be rounded down.

Solved by S. B. in 19 mins

I'd like to perform the following calculations in the order they are presented in
C1=A1/4 [answer needs rounded up and next calc to be based on rounded number]
D1=C1/3.5 [answer needs rounded up and next calc to be based on rounded number]
C2=C1 answer + D1 answer
E1=C1 answer x 6
F1=E1 answer x 3
My problem so far has been that the original fraction (when one occurs) has been used to make the next calculation, and not the rounded up number.

Solved by B. B. in 25 mins