# Rounding Functions

In this tutorial I will show how to use the `ROUND`, `ROUNDUP` and `ROUNDDOWN` functions in Excel.

If all you want is to make your number look better without decimals, you shouldn’t use the ROUND functions as by using them you’ll loose information. In the case where you want to remove decimals, use the formatting options in Excel instead.

## ROUND Function

Use the `ROUND` function to round a number to a given place value. As you might remember from math class, numbers that end in 1, 2, 3, or, 4, get rounded down while numbers that end in 5, 6, 7, 8, or 9 get rounded up.

Look at the examples below to see how to round a number to the place value you want:

1. How to round a number to two decimal places.

2. How to round a number to one decimal place.

2. How to round a number to the nearest integer.

4. How to round a number to the nearest 10.

5. How to round a number to the nearest 100.

## ROUNDUP Function

Use the `ROUNDUP` function to always round up a number away from zero, even if it has values 1, 2, 3, or 4.

Look at the examples below to round a number up the way you want:

1. Rounding a number up to one decimal place.

Note that when you have negative numbers it also rounds ‘up’, which in this case means it makes it more negative.

## ROUNDDOWN Function

Use the `ROUNDDOWN` function to always round a number down towards zero.

Look at the examples below to round down a number the way you want:

1. Rounding a number down to the nearest integer.