ExcelHeroThe ROUND function
Rounds a number to a number of digits.
In German Excel: RUNDEN
How to write it
=ROUND(number, num_digits)- number
- The number to round.
- num_digits
- Digits after the decimal point. 0 gives a whole number.
💡 Negative digits round to tens, hundreds: ROUND(1234,-2) is 1200.
Try it
Round the price of tea to 2 decimals.
A
B
C
1
Item
Price
Rounded
2
Tea
2.456
3
Cake
3.333
4
Juice
4.999
=ROUND(B2, 2) keeps two digits after the point.