ROUND Function

Rounds a number to a set number of decimal places.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A number

Taught hands-on in Level 2: Essential Formulas & Everyday Logic · Frequently Used Functions module

Overview

ROUND changes the actual value to the decimals you choose, using normal rounding: 5 and above rounds up.

Formatting only changes how a number looks. ROUND changes what's stored, so totals of rounded figures add up exactly as shown.

Syntax

=ROUND(number, num_digits) Explain

Arguments

ArgumentRequired?What it does
numberYesThe number to round.
num_digitsYesDecimal places. 0 = whole number; negative values round to tens (−1), hundreds (−2) and so on.

Examples

Example 1 — Rounding tax to the cent

Work out 13% tax, rounded to two decimals.

C2fx=ROUND(B2*13%, 2)
ABC
1ItemPriceTax
2Widget19.992.6
3Gadget4.350.57
4Cable12.51.63
=ROUND(B2*13%, 2) Explain

Example 2 — Rounding to the nearest thousand

Use a negative num_digits for headline figures.

B2fx=ROUND(A2, -3)
AB
1SalesRounded
2125449125000
39850099000
473207000
=ROUND(A2, -3) Explain

Common mistakes

  • Format vs. ROUND. A cell formatted to 2 decimals still holds every decimal. If totals look a cent out, round the values with ROUND.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.