During the period 23/12 to 6/1, we will have slightly longer response times than usual. Merry Christmas and a Happy New Year! 🎄✨

Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.

ROUNDUP, ROUNDDOWN

See more Excel functions
Share

In this lesson we will have a quick look at the RoundUp and Round Down functions.
Both contain two arguments: The number we want to round up or down, and the number of decimal places we want the new number to have.
For ROUNDUP, we write Equals, ROUNDUP, select the number, and write a zero. This will give us the first whole number following the original value. Writing a 1 will give us a number, rounded up, with one decimal. As we see, if we had simply rounded the number, it would have normally rounded down, but since we are using the ROUNDUP function, it rounds upward.
ROUNDDOWN is identical, but rounds the number down instead. If we write Equals, ROUNDDOWN, select the number, and write a zero, we get the whole number before the given number, even though we would naturally round it up instead.
In this lesson we have looked at how to round numbers up or down, using the ROUNDUP and ROUNDDOWN functions respectively.