Get instant live expert help on I need help with rounding to the nearest cent

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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
The demand curve for tickets at an amusement park is: Q=D(p)=190045p Q=D(p)=1900-45p , p > 0 The marginal cost of serving a customer is $14. Using calculus and formulas (but no tables or spreadsheets) to find a solution, what is the profit-maximizing price? Round the equilibrium quantity DOWN to its integer part and round the equilibrium price to the nearest cent.
Solved by S. Q. in 29 mins
Stop rounding numbers, permanently and globally.
Solved by M. J. in 27 mins