# 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