Here are some problems that our users have asked and received explanations on
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.