ROUND function
Round reported decimal hours to two places.
Math and trigonometry
Where can you use it?
Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.
Scenario in the workbook
Round a price to the nearest specified digit. A negative digit count rounds to tens or hundreds.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Raw amount |
| 7 | 12.789 |
| 8 | -12.789 |
| 9 | 128 |
Two decimals
=ROUND(A7,2)Expected result12.79
See the inputs and instructions for all 3 examplesSyntax
ROUND(number, num_digits)
Copyable formulas
English Excel · en-US
=ROUND(7.456,2)Turkish Excel · tr-TR
=YUVARLA(7,456;2)Example and expected result
The 2 rounds the calculated result to two decimal places. Cell formatting changes the display.
Expected result 7.46.
Worked examples
Round a price to the nearest specified digit. A negative digit count rounds to tens or hundreds.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A |
|---|---|
| 6 | Raw amount |
| 7 | 12.789 |
| 8 | -12.789 |
| 9 | 128 |
| Case | Formula | Expected result |
|---|---|---|
| Two decimals | =ROUND(A7,2) |
12.79 |
| Negative amount | =ROUND(A8,2) |
-12.79 |
| Tens | =ROUND(A9,-1) |
130 |