Get instant live expert help on I need help with rounding to the nearest thousand
“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
How do I get a column to add up exactly the values rather than rounding up to the nearest pound?
Solved by F. F. in 28 mins
I have a problem with rounding down times to the nearest hour using the FLOOR function. It rounds down full hours by an hour
Solved by B. H. in 29 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
Stop rounding numbers, permanently and globally.
Solved by M. J. in 27 mins
I need to formula transfer numeric to alphabetic,as like one thousand instead of 1000
Solved by C. C. in 26 mins