# Excel Round Function (round, roundup, rounddown)

### Excel function tutorials

Today I decided to take a deeper look at another very but very useful excel function: the round function in excel. When would you use it? Basically, if you want to determine the precision that you want to display. So what is the difference between this and changing the number of decimals to be displayed either in the format function or in the top menu?

The biggest difference is that when you use rounding, you will be using the rounded number in future calculations while when using the format, you do not actually see what excel is using.

Another important difference is that you can actually round numbers that are over 0. For example, let’s imagine that you had a budget where you wanted to display expenses by category. Let’s use a simplified version here:

Now if I wanted to display these amounts by taking out the “cents”, I could simply use the excel round function as follows:

=ROUND(number,number of decimals)

In my example:

=ROUND(D5,0)

That would give me the following:

Now if I wanted things to look cleaner, I could round everything to the \$10. I would do so by entering the following:

=ROUND(D5,-1)

You get the picture. If I entered -2 for the number of decimals, I would get everything rounded to the nearest hundred dollars and so on. Here is the result:

Now I might want to be conservative. How? I would round down the income numbers and round up the expenses, using the following:

=ROUNDDOWN(D5,-1)
=ROUNDUP(D10,-1)

This would give me the following result: