ROUND

Round a number to a given number of digits

Sponsored Link

ROUND

Purpose 

Round a number to a given number of digits

Return value 

A rounded number.
Syntax 

=ROUND (number, num_digits)

Arguments 

  • number - The number to round.
  • num_digits - The number of digits to which number should be rounded.

Usage notes 

Round works by rounding numbers 1-4 down, and rounding numbers 5-9 up.

The ROUND function rounds numbers to a specified level of precision. It can round to the right or left of the decimal point.

If num_digits > 0,  number is rounded to the specified number of decimal places to the right of the decimal point.

If num_digits < 0,  number is rounded to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).

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

Sponsored Link

0 votes. 0 / 5