# Excel-Formula: Math Formula – ROUND()

`Description: `

The ROUND function in MS excel returns a rounded number based on the specified number of digits.

`Format:`

As Excel Formula : ROUND(number,digits)

Note : ROUND() works slightly diffrent when used as VBA function.Click here to know about it VBA-ROUND()

`Arguments:`
• Number
• Mandatory
• Type: Number
• Number which requires to be rounded.
• digits
• Mandatory
• Type: Number
• Number of digits to the number to

Important Notes:

If number you are rounding ends with 5 then this function will return the number ending with nearest even number, see example

```Round(4.55,1)
Output: 4.6   (round up)

Round(6.85,1)
Output: 6.8 (round down)
```

Other Examples:

```Round(3.33,0)
Output: 3

Round(25.77,1)
Output: 25.8

Round(26.32)
Output: 26
```

Interesting Fact:

You can provide -1 as digits argument, in the case ROUND() will return the nearest Interger divisible by 10. see Example

```Round(26.32,-1)
Output: 20

Round(13,-1)
Output: 10

Round(46,-1)
Output: 50
```