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.

An example of the ROUND function in Excel

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.

Another example of the ROUND function in Excel

Interactive GSheet