ROUND-function

What Is The ROUND Function?

The ROUND Function is categorized under Excel Math and Trigonometry functions and it rounds up a number to a specified number of digits. 

Unlike the ROUNDUP and ROUNDDOWN functions, the ROUND function can round either up or down.

Discover the best online rounding calculators.

ROUND Function Formula

=ROUND(number,num_digits)

The function uses the following arguments:

#1: Number (required argument) – This is a real number that we wish to round.

#2: Num_digits (required argument) – This is the number of digits to which we want to round the number.

Now if the num_digits argument is:

  1. A positive value that is greater than zero, it specifies the number of digits to the right of the decimal point.
  2. Equal to zero, it specifies rounding to the nearest integer.
  3. A negative value that is less than zero, it specifies the number of digits to the left of the decimal point.

Rounding numbers – hardware implementations and implications.

How To Use The ROUND Function In Excel?

To understand the uses of the ROUND function, let’s consider a few examples:

Example #1:

Suppose we are given the following data:

NumberDigits
Remarks
5.1420Round up to the nearest whole number
5.1421
Round up to 1 decimal place
5.1422
Round up to 2 decimal places
2785.23Round up to 3 decimal places
2785.2-1Round up to the nearest 10
2785.2-2Round up to the nearest 100
2785.2-3Round up to the nearest 1000

The results we get in Excel are shown below:

ROUND-function

Learn more about the round half up and round half down modes.

Example #2:

Let’s see how to round prices using the function to the nearest 0.99 value. Suppose we are given the following data:

example-2-2

The formula used is shown below:

formula

The ROUND function would first round 63.39 to 63 and then subtract 0.01 to give 62.99. So, the function with a zero would round the number given to the nearest whole dollar. Once it is rounded, the formula would simply subtract 0.01 from the number to get a .99 value.

We get the result below:

result-1

Understanding the decimal place value.

The ROUNDDOWN Function

The ROUNDDOWN Function rounds down towards zero. 

The ROUNDDOWN Function Formula

=ROUNDDOWN(number,num_digits)

The ROUNDDOWN function uses the following arguments:

#1: Number (required argument) – This is a real number that we wish to round down.

#2: Num_digits (required argument) – This is the number of digits to which we want to round the number.

Now, if the num_digits argument is:

  1. A positive value that is num_digits > number, it specifies the number of digits is rounded down to the specified number of decimal places.
  2. Equal to zero, it specifies rounding to the nearest integer.
  3. A negative value that is num_digits < number, it specifies the number of digits is rounded down to the specified number of decimal places.

The ROUNDUP Function

The ROUNDUP Function rounds up a number away from zero.

ROUNDUP Function Formula

=ROUNDUP(number,num_digits)

The ROUNDUP function uses the following arguments:

#1: Number (required argument) – This is a real number that we wish to round up.

#2: Num_digits (required argument) – This is the number of digits to which we want to round the number.

Now, if the num_digits argument is:

  1. A positive value, it specifies the number of digits to the right of the decimal point.
  2. Equal to zero, it specifies rounding to the nearest integer.
  3. A negative value, it specifies the number of digits to the left of the decimal point.
© 2021 rounding.to . Powered by WordPress. Theme by Viva Themes.