In this tutorial I will show how to use the ROUND, ROUNDUP and ROUNDDOWN functions in Excel.
Before you start with the ROUND functions, please think about what you’re trying to achieve.
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. Rounding a number to two decimal places2. How to round a number to one decimal place. Rounding a number to one decimal place2. How to round a number to the nearest integer. Rounding a number to the nearest integer4. How to round a number to the nearest 10. Rounding a number to the nearest 105. How to round a number to the nearest 100. Rounding 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. Use the ROUNDUP function to always round a number up away from zeroNote that when you have negative numbers it also rounds ‘up’, which in this case means it makes it more negative. Use the ROUNDUP function to always round a number up away from zero
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. Use the ROUNDDOWN function to always round a number down towards zeroPlease note that also with negative numbers it will round down, which actually makes the number more positive than the original. Use the ROUNDDOWN function to always round a number down towards zero
