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