Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### kudret

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

#### Garf13LD

What is your criteria for rounding?

#### kudret

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.

#### Garf13LD

=ceiling((c4/34)*100,0.5)

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On