ROUND
Rounds a number to a set number of digits.
How it’s written
ROUND(number, digits)Example
| A | |
|---|---|
| 1 | Value |
| 2 | 1,234.567 |
=ROUND(A2,1)Result: 1,234.6
Rounds to one decimal place.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Formatting only changes how a number looks. ROUND changes the value itself.
Practice it properly
Rounding properly gives you real tasks, with your formulas tested on data you haven’t seen.