Math
ROUND
Definition
ROUND returns a number rounded to a given number of digits.
Syntax
=ROUND(number, num_digits)
Arguments
| Argument | Meaning |
|---|---|
number |
The value to round, or the cell holding it. |
num_digits |
How many digits to keep. 0 rounds to a whole number; 1 keeps one digit after the decimal point. |
Worked example
A baker weighs ingredients in grams. The weights are in B2:B4.
| A: Ingredient | B: Weight (g) |
|---|---|
| Flour | 3.47 |
| Sugar | 5.81 |
| Salt | 1.09 |
Formula: =ROUND(B2,1)
Result: 3.5. The second decimal of 3.47 is 7, so the first decimal rounds from 4 up to 5.
Practice
Cell B2 holds 19.6. In C2, write a formula that rounds it to 0 decimal places.
- In C2, write a ROUND formula that rounds B2 to 0 decimal places.
- C2 should show B2 rounded to the nearest whole number.
Step 1 of 2
Enter =ROUND(B2,0) in C2.
B2 is 19.6, so rounding to 0 decimal places gives 20.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses ROUND.
C2 now shows 20.
Related functions
ROUND is often applied to a total from SUM or a mean from AVERAGE when you want that result kept to a set number of digits.
Common mistake
Changing the cell's number format to hide extra decimals instead of using ROUND: later formulas still read the unrounded value.