← Back to level 1
Level 1Next
ROUND
A easy precision formula for rounding values to a chosen number of digits without always forcing the result up or down.
Syntax
=ROUND(...)Step-by-step explanation
- 1Select the numeric value or range that needs to be adjusted.
- 2Choose the rounding or comparison function that matches the outcome you want.
- 3Press Enter and compare the returned value with the original number.
Common mistakes
Rounding too early before later calculations
Choosing the wrong number of digits
Using it when you need a guaranteed up or down result
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=ROUND(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =ROUND(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use ROUND when a report needs a balanced rounded value for prices, scores, or percentages.
Match against the syntax block above.