Hi. In this Excel tutorial, we’re going to go over 4 ways to round in Excel. It might seem odd that there’s so many rounding functions but
having them helps add flexibility to meet the needs of different projects. In this tutorial,
we’ll look at the ROUND, ROUNDUP, ROUNDDOWN and MROUND functions in Excel.
With the exception of MROUND, to use the rounding functions in this example, you’ll need to know 2 pieces of information –
1. the number that you want to round and 2. the number of digits you want to round the number to. When asked for the number of
digits to round to, this refers to how far or close you need to round from the decimal point. For example,
to round to digits to the right of the decimal point, you will use a positive number. To round to digits to the left of the decimal point, you will
use a negative number. And, also, as a refresher, conventional rounding rules say that for numbers ending in 0 to 4, you would round
down. And for numbers ending with 5 through 9, you would round up.
And, by the way, if you’re finding this tutorial helpful, don’t forget to Like the video and subscribe to the channel for more Excel tips!
So, let's take a look. To round our example number 637.148 to the nearest whole number, we can use the ROUND function, reference
the number or you can type it in. Whichever one. And then, for the number of digits we'll use zero because for a
whole number, you don't want anything to the right of the decimal point.
And it rounds to 637.
So, then,
if we were to do the same thing but used a -1 for the number of digits, it would round to 640. And if we use a negative 2, it would round to
600. On the other hand, if we were to use a 1, it would round to the nearest tenth because that's the first number to the right of the
decimal point. Using a 2 would round it to the nearest hundredth.
And using a 3 would round to the nearest thousandth. So, applying the ROUNDUP and the ROUNDDOWN functions work very
similarly to the ROUND function, except that using them forces Excel to ignore a little bit some of the conventional rounding rules. And
what I mean by that is that ROUNDUP will always round higher, away from zero,
where ROUNDDOWN will always round lower, towards zero. So, let's take a look. If we are to copy what we used in our ROUND formula and
we'll use Find and Replace to change ROUND to ROUNDUP.
Notice how our numbers rounded up farther from zero. So, like the hundreds, instead of 600
went to 700. 640 stayed the same. Our whole number went to 638 and so on.
The ROUNDDOWN formula, however, will round towards zero rather than away. So, let's
Find and Replace ROUNDUP with ROUNDDOWN
and notice how, now, our numbers have rounded down towards zero rather than farther away. So, like our hundreds rounded 637 to
600 rather than 700, 630 rather than 640, the whole number
will remain at 637,
and so on. The MROUND function works a little bit differently in that it rounds to the nearest multiple - which is just a number that
it can be divided by without having a remainder. So, a common example is if you want to round to the
nearest 5 - or the nearest multiple of 5. Which, in this example,
we type MROUND, reference our number, and tell it to round to the nearest multiple of 5 - it would round to 635. So, I hope you enjoyed
this tutorial on how to round in Microsoft Excel. If you did, please make sure to Like the video and don’t forget to subscribe to this channel.
Thanks!