ROUND Function - Excel
Overview
The ROUND function in Excel is a useful tool for rounding a number to a specified number of digits. This function adjusts a numerical value to a specified level of precision.
Example:
=ROUND(12.567392, 2)
Syntax:
=ROUND(number, num_digits)
number
: This is the numerical value that you want to round.
num_digits
: This is the number of digits to which you want to round the number
. It can be positive (to round to the right of the decimal point) or negative (to round to the left of the decimal point).
Example
In this example, the ROUND function takes the number 25.235264 and rounds it to the 2nd decimal point. The final output is 25.24.