What is the ROUND Function
The ROUND function rounds a number to a specified number of decimal places using standard rounding rules. It is one of the most important functions for financial and statistical calculations.
Formula: =ROUND(number, num_digits)
Practical Example 1
A2 contains 3.14159. Round to 2 decimals.
Type: =ROUND(A2, 2)
Result: 3.14
Practical Example 2
Round to the nearest integer.
Type: =ROUND(A2, 0)
Result: 3
Practical Example 3
Round to the nearest tens.
Type: =ROUND(A2, -1)
Result: the value rounded to the nearest 10
Practical Example 4
Round to 3 decimals.
Type: =ROUND(A2, 3)
Result: 3.142
When to Use It
ROUND is used for financial calculations, for price rounding, for statistical reports, for preventing rounding drift in sums, and for any formula where you need a clean decimal value.