Math
Rounding to a whole number
Definition
Rounding to a whole number means giving ROUND a decimal and 0 digits.
Syntax
=ROUND(number, num_digits)
Arguments
| Argument | Meaning |
|---|---|
number |
The cell or value to round. |
num_digits |
The digit count. 0 rounds to the nearest whole number. |
Worked example
A scale lists a reading in B2 that must be stored as a whole number.
| A: Item | B: Weight |
|---|---|
| Bag | 7.6 |
| Box | 2.1 |
| Tin | 5.9 |
Formula: =ROUND(B2,0)
Result: 8. The first decimal of 7.6 is 6, which is 5 or above, so the weight rounds up to 8.
Practice
Cell A2 holds 4.4. In B2, write a formula that rounds it to 0 decimal places.
- In B2, write a ROUND formula that rounds A2 to 0 decimal places.
- B2 should show A2 rounded to the nearest whole number.
Step 1 of 2
Enter =ROUND(A2,0) in B2.
A2 is 4.4, so rounding to 0 decimal places gives 4.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses ROUND.
B2 now shows 4.
The next lesson is Rounding to two decimal places.
Related functions
ROUND is the function that turns that decimal into a whole number when the digit count is 0.
Common mistake
Using INT instead, as in =INT(B2): INT cuts off the decimal and returns 7, instead of rounding 7.6 up to 8.