How to Use ROUND Function in Excel

Complete tutorial on Excel's most versatile rounding function

Understanding the ROUND Function

The ROUND function is Excel's primary tool for rounding numbers. Unlike ROUNDUP or ROUNDDOWN which always round in one direction, ROUND follows standard mathematical rounding rules: 5 and above rounds up, below 5 rounds down.

ROUND Function Syntax

=ROUND(number, num_digits)

number: The value you want to round

num_digits: Number of decimal places (positive) or place value (negative)

Quick Example

=ROUND(123.456, 2) → 123.46

Rounds to 2 decimal places

Understanding the num_digits Parameter

The num_digits parameter is the key to ROUND's flexibility. It controls both the direction and precision of rounding:

Positive Numbers: Decimal Places

2: Two decimal places (0.01)
1: One decimal place (0.1)
0: Whole number (no decimals)

=ROUND(3.14159, 2) → 3.14

=ROUND(3.14159, 1) → 3.1

=ROUND(3.14159, 0) → 3

Negative Numbers: Place Values

-1: Tens place (10, 20, 30...)
-2: Hundreds place (100, 200...)
-3: Thousands place (1000, 2000...)

=ROUND(1234, -1) → 1230

=ROUND(1234, -2) → 1200

=ROUND(1234, -3) → 1000

Remember: Positive num_digits = decimal precision, Negative num_digits = place value rounding

Detailed Examples

Rounding to Decimal Places (Positive num_digits)

Two Decimal Places

=ROUND(123.456, 2) → 123.46

=ROUND(123.454, 2) → 123.45

=ROUND(99.995, 2) → 100.00

Common for currency and financial calculations

One Decimal Place

=ROUND(123.456, 1) → 123.5

=ROUND(123.44, 1) → 123.4

=ROUND(3.75, 1) → 3.8

Useful for percentages and measurements

Whole Numbers (Zero Decimals)

=ROUND(123.456, 0) → 123

=ROUND(123.5, 0) → 124

=ROUND(99.9, 0) → 100

Standard for counts and whole units

Rounding to Place Values (Negative num_digits)

Tens Place (-1)

=ROUND(123.456, -1) → 120

=ROUND(127, -1) → 130

=ROUND(155, -1) → 160

Results end in 0: 10, 20, 30, 40...

Hundreds Place (-2)

=ROUND(123.456, -2) → 100

=ROUND(567, -2) → 600

=ROUND(1234, -2) → 1200

Results end in 00: 100, 200, 300...

Thousands Place (-3)

=ROUND(1234, -3) → 1000

=ROUND(5678, -3) → 6000

=ROUND(12345, -3) → 12000

Results end in 000: 1000, 2000, 3000...

Step-by-Step Tutorial

Example 1: Rounding Prices to 2 Decimal Places

Step 1: Enter your price in cell A1: 12.3456

Step 2: Click cell B1 where you want the rounded result

Step 3: Type =ROUND(A1, 2)

Step 4: Press Enter

Result: 12.35 (rounded to 2 decimal places)

Example 2: Rounding to Nearest Hundred

Step 1: Enter your number in cell A1: 1234

Step 2: Click cell B1

Step 3: Type =ROUND(A1, -2)

Step 4: Press Enter

Result: 1200 (rounded to nearest hundred)

Example 3: Rounding Multiple Values

Step 1: Enter values in A1:A5 (multiple prices)

Step 2: In B1, type =ROUND(A1, 2)

Step 3: Press Enter

Step 4: Drag the fill handle from B1 down to B5

Result: All values in column A are now rounded in column B

Common Use Cases

Financial Calculations

Round currency to cents (2 decimal places)

Price after tax: $45.678

=ROUND(45.678, 2) → $45.68

Grade Point Average

Round GPA to one decimal place

Calculated GPA: 3.67894

=ROUND(3.67894, 1) → 3.7

Statistical Results

Round averages to 2 decimal places

Average: 87.34562

=ROUND(87.34562, 2) → 87.35

Budget Estimates

Round budget to nearest thousand

Budget: $47,823

=ROUND(47823, -3) → $48,000

Troubleshooting Common Errors

Error: #VALUE!

Cause: The number argument is not numeric (text or error)

Wrong: =ROUND("abc", 2)

Correct: =ROUND(123.45, 2)

Issue: Result shows too many decimals

Cause: Cell formatting is overriding the ROUND result

Solution: Right-click cell → Format Cells → Number → Set decimal places to match your ROUND formula

Issue: Rounding doesn't seem to work

Cause: Using positive num_digits when you need negative (or vice versa)

=ROUND(1234, 2) → 1234.00 (adds decimals)
=ROUND(1234, -2) → 1200 (rounds to hundreds)

Tip: Rounding vs Formatting

ROUND function: Actually changes the value (12.345 becomes 12.35)
Cell formatting: Only changes how it's displayed (12.345 displays as 12.35 but stores 12.345)

Best Practices

1. Round at the End of Calculations

Perform all calculations first, then round the final result. Rounding intermediate steps can compound errors.

Good: =ROUND(A1*B1*C1, 2)

Avoid: =ROUND(A1,2)*ROUND(B1,2)*ROUND(C1,2)

2. Be Consistent with Decimal Places

Use the same num_digits value throughout your spreadsheet for consistency. If working with money, always use 2 decimal places.

3. Document Your Rounding Rules

Add a note in your spreadsheet explaining your rounding approach. Example: "All prices rounded to 2 decimal places using standard rounding (0.5 rounds up)."

4. Consider Using Named Ranges

Create a named cell for your decimal places (e.g., "DecimalPlaces" = 2), then use=ROUND(A1, DecimalPlaces). This makes it easy to change precision across your entire workbook.