# round number in excel

#### Ariful Islam

##### New Member
I want to round the number for the decimal part 0.6, e.g if the calculated is 4.6 or 7.79 it rounds up, otherwise if the calculated is 2.5 or 9.43 it would round down. Can anyone help me?

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### alansidman

##### Well-known Member
Rounds to how many decimal places? Give a full explanation of what you want.

#### igold

##### Well-known Member
You do realize that normally any number whose decimal is .5 or higher rounds up. In your statement:

otherwise if the calculated is 2.5 or 9.43 it would round down

Are you looking to create some sort of custom rounding...

#### Ariful Islam

##### New Member
Rounds to how many decimal places? Give a full explanation of what you want.

two decimal places

#### Ariful Islam

##### New Member
You do realize that normally any number whose decimal is .5 or higher rounds up. In your statement:

Are you looking to create some sort of custom rounding...
yes, pls help me

#### igold

##### Well-known Member
The brevity of your answers is not helping us help you. As alansidman said in Post #2 , we need a full explanation of what you want to accomplish. Preferably with before and after examples.

Replies
3
Views
40
Replies
18
Views
128
Replies
1
Views
58
Replies
7
Views
56
Replies
5
Views
30