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:

- A positive value that is greater than zero, it specifies the number of digits to the right of the decimal point.
- Equal to zero, it specifies rounding to the nearest integer.
- 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:

Number | Digits | Remarks |

5.142 | 0 | Round up to the nearest whole number |

5.142 | 1 | Round up to 1 decimal place |

5.142 | 2 | Round up to 2 decimal places |

2785.2 | 3 | Round up to 3 decimal places |

2785.2 | -1 | Round up to the nearest 10 |

2785.2 | -2 | Round up to the nearest 100 |

2785.2 | -3 | Round up to the nearest 1000 |

The results we get in Excel are shown below:

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:

The formula used is shown below:

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:

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:

- A positive value that is num_digits > number, it specifies the number of digits is rounded down to the specified number of decimal places.
- Equal to zero, it specifies rounding to the nearest integer.
- 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:

- A positive value, it specifies the number of digits to the right of the decimal point.
- Equal to zero, it specifies rounding to the nearest integer.
- A negative value, it specifies the number of digits to the left of the decimal point.