Sum, Count & Average

Excel formula for Round a number to set decimals

Round a value to a fixed number of decimal places with ROUND.

Copy this formula

=ROUND(A2, 2)

How the formula works

ROUND takes the number and the digit count. Use 2 for cents, 0 for whole numbers, and a negative number to round to tens or hundreds. Use ROUNDUP or ROUNDDOWN to always round in one direction.

Examples

=ROUND(3.14159, 2)→3.14

Rounds to two decimals.

=ROUND(1280, -2)→1,300

Rounds to the nearest hundred.

Other ways to do this

Always round up

=ROUNDUP(A2, 0)

Rounds away from zero.

FAQ

Does ROUND change the underlying value?

Yes — unlike number formatting, ROUND returns a genuinely rounded number used in further math.

Related formulas

Weighted average Percentage of total

Functions used

ROUND ROUNDUP ROUNDDOWN

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free