How to Use Excel ROUND Function (Examples + Video)

Excel ROUND Function (Example + Video)

When to use Excel ROUND Function

ROUND function can be used when you want to return a number rounded to a specified number of digits.

What it Returns

A number rounded to a specified number of digits.

Syntax

=ROUND(number, num_diguts).

Input Arguments

• number – the number that you want to round.
• num_digits – the number of digits to which you want to round the number argument.

Additional Notes

• If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
  • For example, =ROUND(500.51,1) would return 500.5.
• If num_digits is 0, the number is rounded to the nearest integer.
  • For example, =ROUND(500.51,0) would return 501.
• If num_digits is less than 0, the number is rounded to the left of the decimal point.
  • For example, =ROUND(500.51,-1) would return 501.

Excel ROUND Function – Live Example

Excel ROUND Function – Video Tutorial

Related Excel Functions:

• Excel INT Function.
• Excel MOD Function.
• Excel RAND Function.
• Excel RANDBETWEEN Function.
• Excel RANK Function.
• Excel LARGE Function.
• Excel MAX Function.
• Excel MIN Function.
• Excel SMALL Function

Other Useful Excel tutorials:

• How to Stop Excel from Rounding Numbers (Decimals/Fractions)
• How to Round to the Nearest Integer or Multiple of 0.5 / 5 / 10 in Excel
• Round to the Nearest 1000 in Excel