FormulaCraft

ROUND / ROUNDUP / ROUNDDOWN

ROUND rounds to the nearest value at the chosen number of decimals; ROUNDUP and ROUNDDOWN always round in one direction.

Excel
=ROUND(A2, 2)
Google Sheets
=ROUND(A2, 2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the number to round.
  2. 22 is the number of decimal places.
  3. 3Use 0 for a whole number, or a negative number to round to tens or hundreds.

Need a version for your data?

Try: “Round the value in A2 to 2 decimal places”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: