Excel Function: ROUND

The Excel function ROUND allows you to round a number to X digits after the decimal point.

Usage:

=ROUND(number, num_digits)

Usage Example

Select the ROUND function and enter:

• Number: the number to round
• Num_digits: the desired number of decimals

=ROUND(A2,2)

Click OK.

The number is rounded.

Then simply drag the formula down: