Get instant live expert help on How do I rounded to the nearest tenth
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Write a formula in cell B253 to calculate the average rating of all the movies rounded result to the nearthest tenth
Solved by B. J. in 16 mins
My formula in column S is not working, it should be the difference between column M and (O,P,Q,R), rounded down to the nearest 100 with a min of 0, can you help?
Solved by X. W. in 13 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
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