ROUND function

The ROUND function in Excel is used to round a number to a specified number of digits. It can round numbers both up and down based on standard rounding rules.

Syntax

=ROUND(number, num_digits)

Parameters

1. number (required): The number you want to round.
2. num_digits (required): The number of digits to round to:
   • 0 rounds to the nearest whole number.
   • A positive value (n) rounds to n decimal places.
   • A negative value rounds to the left of the decimal point.

Examples

1. Round 123.456 to 2 decimal places:

   =ROUND(123.456, 2)
   

   Result: 123.46

2. Round 123.456 to the nearest whole number:

   =ROUND(123.456, 0)
   

   Result: 123

3. Round 123.456 to the nearest tens place:

   =ROUND(123.456, -1)
   

   Result: 120

4. Round a number in a cell (e.g., A1) to 3 decimal places:

   =ROUND(A1, 3)
   

Notes

• If num_digits is:
  • Greater than 0, it rounds to the specified number of decimal places.
  • 0, it rounds to the nearest integer.
  • Less than 0, it rounds to the left of the decimal point.
• Rounding behavior: Numbers are rounded up if the digit immediately following the rounding place is 5 or greater; otherwise, they are rounded down.

Related Functions

• ROUNDUP: Always rounds up, away from zero.
• ROUNDDOWN: Always rounds down, toward zero.
• MROUND: Rounds to the nearest multiple of a specified number.
• TRUNC: Truncates a number to an integer by removing the fractional part, without rounding.

These functions provide more control based on specific rounding needs.