ROUNDUP, ROUNDDOWN

Back to all functions

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.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.

Contact