Quick Answer

ROUND Function

ROUND rounds numbers to a given number of decimal places, following standard rounding rules.

Syntax

ROUND

(number, num_digits)

Parameters

Parameter	Description	Required
number	The number to round.	Required
num_digits	The number of decimal places to round to. Use 0 for whole numbers.	Required

Basic Example

Round to 2 decimal places

=ROUND(3.14159, 2)

Result3.14

Rounds 3.14159 to 2 decimal places, resulting in 3.14.

Advanced Examples

Example 1: Round to nearest 100

Financial reporting

Round numbers to the nearest hundred

=ROUND(A1, -2)

Result: 500

Using -2 rounds to the nearest hundred: 456 becomes 500.

Example 2: Round to whole number

Inventory management

Round decimal quantities to whole units

=ROUND(A1, 0)

Result: 12

Rounds 12.6 to 13 and 12.4 to 12.

How ROUND Works

ROUND uses standard mathematical rounding: 0.5 and above rounds up, below 0.5 rounds down. Positive num_digits rounds to decimal places, negative num_digits rounds to tens, hundreds, etc.

1

Select output cell

Choose where the rounded result should appear.

2

Enter formula

Type =ROUND(number, decimal_places).

3

Press Enter

The result shows the rounded number.

Important Notes & Limitations

ROUND always rounds 0.5 up (bankers rounding uses MROUND instead).
For always rounding up, use ROUNDUP; for always rounding down, use ROUNDDOWN.

Common Errors & Fixes

#VALUE!Non-numeric arguments

Fix: Ensure both arguments are numbers.

Download Practice File

Practice ROUND with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the ROUND function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

ABS

ABS converts negative numbers to positive, leaving positive numbers unchanged.

ACOS

Returns the angle (in radians) whose cosine is the supplied number.

ASIN

Returns the angle (in radians) whose sine is the supplied number.

ATAN

Returns the angle (in radians) whose tangent is the supplied number.

ATAN2

Returns the angle in radians to a point given by its x and y coordinates.

CEILING.MATH

Rounds up to a multiple of significance, with a mode for negative numbers.

Frequently Asked Questions

What does negative num_digits mean?

Negative values round to tens, hundreds, thousands, etc. -1 rounds to nearest 10, -2 to nearest 100.

What is bankers rounding?

Bankers rounding (MROUND) rounds 0.5 to the nearest even number to reduce bias. Standard ROUND always rounds 0.5 up.