ROUND

Beginner

Math & Calculation

Rounds a number to a specified number of digits. Essential for financial calculations and display formatting.

Syntax
=ROUND(number, num_digits)
Parameters
number
Required
(number)

Number to round

num_digits
Required
(number)

Number of digits to round to

Examples
Real-world examples to help you understand how to use ROUND

Round to 2 decimal places

=ROUND(3.14159, 2)

Rounds to 2 decimal places

Result: 3.14

Round to nearest whole number

=ROUND(125.75, 0)

Rounds to nearest integer

Result: 126

Round to nearest 10

=ROUND(156, -1)

Negative num_digits rounds left of decimal

Result: 160

Common Use Cases
  • ✓Format currency values
  • ✓Clean up calculations
  • ✓Round measurements
  • ✓Financial reporting
  • ✓Display friendly numbers
Pro Tips
  • 💡Positive num_digits: decimals
  • 💡Zero: nearest whole number
  • 💡Negative: rounds left of decimal
  • 💡Use ROUNDUP/ROUNDDOWN for directional rounding
Common Errors
  • ⚠️Confusion with ROUNDUP/ROUNDDOWN
  • ⚠️Not understanding negative num_digits
  • ⚠️Expecting ROUND to change cell format
Related Formulas
ROUNDUPROUNDDOWNTRUNCINTCEILINGFLOOR

Need a Custom ROUND Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula