Get instant live Excel expert help to learn how to round a number in Excel

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

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.

My grand total is 34836.01 I need round total or close to 15000.00 is there a way

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.

How to do excel round to nearest 1000 with a formula in excel

I want excel roundup to next whole number with multiple cells containing whole numbers to be rounded to either 5 or 0

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%

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)

HI need help formatting a pivot table. I need borders round the columns etc

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