Learn how to use Excel’s ROUND function effectively. ROUND rounds a number to a specified number of decimal places.

Syntax

=ROUND(number, num_digits)

• number: The number you want to round
• num_digits: The number of digits to round to (positive for decimals, negative for left of decimal)

Examples

1. Round to 2 decimal places:
   =ROUND(123.456, 2)
   Result: 123.46

2. Round to whole number:
   =ROUND(123.456, 0)
   Result: 123

3. Round to tens:
   =ROUND(123.456, -1)
   Result: 120

Advanced Tips

• Positive num_digits rounds right of decimal
• Negative num_digits rounds left of decimal
• Zero rounds to nearest whole number
• Use with other functions:
  =ROUND(AVERAGE(A1:A10), 2)

Common Errors

• #VALUE!: Invalid number format
• #NAME?: Function name misspelled
• Unexpected results: Check num_digits sign