Get instant live expert help on round to thousands in excel

“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

Rounding Financial Statements: I have attached a Balance sheet as an example where the totals are reported in thousands. Is there any trick to round because the "Round" formula does not work every time (I have highlighted problem areas as an example)?
Solved by X. H. in 16 mins
I am trying to round a pivot table formula to the thousands. How do I incorporate the =ROUND(below,-3)? Here's the formula =(GETPIVOTDATA("Annual Budget",Bgt_Mattress!$A$3,"Store","1001 - Nitey-Nite Miami")+GETPIVOTDATA("Annual Budget",Bgt_Pillow!$A$3,"Store","1001 - Nitey-Nite Miami")+GETPIVOTDATA("Annual Budget",Bgt_Other!$A$3,"Store","1001 - Nitey-Nite Miami"))*F5
Solved by C. U. in 21 mins
in excel round(89.5) = ???? please give me answer to this question
Solved by S. Q. in 25 mins
How to I round up to the next 1000 with a formula in excel
Solved by S. Q. in 28 mins
Excel spreadsheet with thousands of contacts in it, data is mismatched with info in wrong fields, duplicate names etc..
Solved by A. S. in 13 mins