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

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