How to use ROUND function in Excel?

The `ROUND` function in Excel is used to round a number to a specified number of digits. Its syntax is simple and works as follows:

Syntax

ROUND(number, num_digits)

number: This is the number that you want to round. It can be a direct numerical value, or a reference to a cell containing the number you want to round.
num_digits: This specifies how many digits you want to round the number to.

If `num_digits` is greater than 0, the number is rounded to the specified number of decimal places.
If `num_digits` is 0, the number is rounded to the nearest integer.
If `num_digits` is less than 0, the number is rounded to the left of the decimal point (to the nearest 10, 100, 1000, etc.).

Examples

   =ROUND(123.4567, 2)

Round a number to two decimal places

This will return `123.46`.

   =ROUND(123.4567, 0)

Round a number to the nearest integer

This will return `123`.

   =ROUND(123.4567, -1)

Round a number to the nearest ten

This will return `120`.

   =ROUND(A1, 2)

Round a cell reference

If the value in cell A1 is `123.4567`, this will return `123.46`.

Notes

The `ROUND` function rounds numbers up or down based on standard rounding rules, i.e., if the digit after the last significant digit is 5 or more, it rounds up.
For different rounding functions, you may also consider `ROUNDUP` and `ROUNDDOWN`, which specifically round a number up (away from zero) or down (towards zero), respectively.

By using the `ROUND` function effectively, you can ensure the numbers in your Excel spreadsheets are tidy and as precise as needed for your calculations or reports.

facebooklinkedin