Math
Rounding to two decimal places
Definition
Rounding to two decimal places means giving ROUND a decimal and 2 digits.
Syntax
=ROUND(number, num_digits)
Arguments
| Argument | Meaning |
|---|---|
number |
The cell or value to round. |
num_digits |
The digit count. 2 keeps two places after the decimal. |
Worked example
A rate sheet stores a long decimal in B2 that must be kept to cents.
| A: Rate | B: Amount |
|---|---|
| Peak | 2.678 |
| Off | 1.204 |
| Night | 0.955 |
Formula: =ROUND(B2,2)
Result: 2.68. The third decimal of 2.678 is 8, so the second decimal rounds from 7 up to 8.
Practice
Cell A2 holds 3.141. In B2, write a formula that rounds it to 2 decimal places.
- In B2, write a ROUND formula that rounds A2 to 2 decimal places.
- B2 should show A2 rounded to 2 decimal places.
Step 1 of 2
Enter =ROUND(A2,2) in B2.
A2 is 3.141, so rounding to 2 decimal places gives 3.14.
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 3.14.
The next lesson is Counting cells that hold one word.
Related functions
ROUND is the function that keeps two digits after the decimal when the digit count is 2.
Common mistake
Rounding to a whole number, as in =ROUND(B2,0): that returns 3, not 2.68.