Get instant live Excel expert help to learn how to round a number 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

How to round in excel with condition. Can I create a rule that says for example $0.50 to $0.99 round up to nearest dollar and $0.01 to $0.29 round down
Solved by I. Y. in 20 mins
I am attempting to get an answer which says: If F3 > E3 Then = negative Growth Space If F3 < E3 Then [F3 * G3] until F3 > E3 = # of Years of expected growth. F3 = 9.6 E3 = 6 G3 = .04 Understanding this is not easy. In my example, it technically takes 3 years for the 6 to turn to 7 due to 4% of six is not a whole number. Once it gets about 6.5, then we round up to the whole; and start over. So based on this example, the long hand answer is 9 years.
Solved by C. J. in 23 mins
My grand total is 34836.01 I need round total or close to 15000.00 is there a way
Solved by C. J. in 14 mins
I am trying to add a row of numbers that include decimals. When I use the sum function it rounds the total. I know how to round but I don't know how to not round. Please advise.
Solved by E. H. in 20 mins
How to do excel round to nearest 1000 with a formula in excel
Solved by S. Q. in 28 mins
I want excel roundup to next whole number with multiple cells containing whole numbers to be rounded to either 5 or 0
Solved by M. H. in 27 mins
I have a formula that calculates a %, but I have a few that are less than 0%, and the cell gets an Error.. How can I make a "less than 0%, round up to 0%
Solved by E. J. in 26 mins
Hello I have a set of VLOOKUP values which are already defined by a filter (Name) but i also want them defined further by filtering the data for both name and round (week)
Solved by I. H. in 30 mins
HI need help formatting a pivot table. I need borders round the columns etc
Solved by A. B. in 14 mins
I need to multiply a number by two then take the product and round to the nearest whole number all in one cell if possible
Solved by M. E. in 30 mins