Use the ROUND function

The ROUND function in Excel rounds a number to a specified number of digits. 

Syntax: =ROUND(number, num_digits)

• If num_digits is greater than 0, the number is rounded to the specified number of decimal places.

• If num_digits is 0, the number is rounded to the nearest integer.

• If num_digits is less than 0, the number is rounded to the left of the decimal point.

Examples   :

=ROUND(2.15, 1) result is 2.2

=ROUND(2.149, 1) result is 2.1

=ROUND(-1.475, 2) result is -1.48

=ROUND(21.5, -1) result is 20

Tip: For more information on rounding functions, see ROUND function.

The ROUND function in Excel rounds a number to a specified number of digits. 

Syntax: =ROUND(number, num_digits)

• If num_digits is greater than 0, the number is rounded to the specified number of decimal places.

• If num_digits is 0, the number is rounded to the nearest integer.

• If num_digits is less than 0, the number is rounded to the left of the decimal point.

Examples   :

=ROUND(2.15, 1) result is 2.2

=ROUND(2.149, 1) result is 2.1

=ROUND(-1.475, 2) result is -1.48

=ROUND(21.5, -1) result is 20

The ROUND function in Excel rounds a number to a specified number of digits. 

Syntax: =ROUND(number, num_digits)

• If num_digits is greater than 0, the number is rounded to the specified number of decimal places.

• If num_digits is 0, the number is rounded to the nearest integer.

• If num_digits is less than 0, the number is rounded to the left of the decimal point.

Examples   :

=ROUND(2.15, 1) result is 2.2

=ROUND(2.149, 1) result is 2.1

=ROUND(-1.475, 2) result is -1.48

=ROUND(21.5, -1) result is 20