Discussion in 'Business Applications' started by kudret, Jan 1, 2013.

Not open for further replies.

Joined:
Jan 1, 2013
Messages:
2
Hello,

Could you help me about how to round the numbers that are already calculated by a formula in the same cells? For example, I have a number, which is 26,6666667, in D4 cell. The formula I used to have this number is =(C4/34)*100. However, I want this number rounded to 27 by a formula in the same D4 cell. Another number I have is 33,3333333 in same column in D7 cell, and I want this number to display as 33.5 in D7 cell. I guess I need to use an "IF" formula but I don't know how to do it. Please help!

Kudret

2. ### Garf13LD

Joined:
Apr 17, 2012
Messages:
455
What is your criteria for rounding?

Joined:
Jan 1, 2013
Messages:
2
Thanks for responding Garf13LD. If the first digit after decimal point is greater than "5," I want to roundup it to the next even number. For example, if the number is "26.6" I want it to display as 27. If the first digit is less than "5" it should be rounded to half number. For example, suppose the number is 33.33, and I want it to display as 33.5. I hope it's not too complicated, and I was clear about explaining it.

Thanks again.

4. ### Garf13LD

Joined:
Apr 17, 2012
Messages:
455
=ceiling((c4/34)*100,0.5)

As Seen On