ExcelFlux

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

RowA
6Raw amount
712.789
8-12.789
9128
Two decimals
=ROUND(A7,2)

Expected result12.79

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference