ROUNDUP Function
Rounds up a given number away from zero
Rounds up a given number away from zero
The ROUNDUP Function is categorized under Math and Trigonometry functions. The function will round up a number away from zero.
As a financial analyst, the ROUNDUP function is useful as it helps round a number and eliminate the least significant digits, simplifying the notation but keeping close to the original value.
=ROUNDUP(number,num_digits)
The ROUNDUP function uses the following arguments:
Now, if the num_digits argument is:
To understand the uses of the ROUNDUP function, let’s consider a few examples:
Suppose we are given the following data:
Number | Digits | Remarks |
---|---|---|
5.142 | 0 | Round up to the nearest whole number |
5.142 | 1 | Round up to 1 decimal place |
5.142 | 2 | Round up to 2 decimal places |
2785.2 | 3 | Round up to 3 decimal places |
2785.2 | -1 | Round up to the nearest 10 |
2785.2 | -2 | Round up to the nearest 100 |
2785.2 | -3 | Round up to the nearest 1000 |
2785.2 | -4 | Round up to the nearest 10000 |
The results we get in Excel are shown below:
Suppose we are given the following data:
Date | Quarter |
---|---|
01/31/18 | 1 |
04/15/18 | 2 |
07/01/18 | 3 |
If we wish to calculate the quarter (i.e. 1, 2, 3, 4) from a date, we can use the ROUNDUP function together with the MONTH function. The formula to be used is:
The formula above extracts the month as a number between 1-12, then divides the number by 3. The result is then rounded up to the nearest whole number using the ROUNDUP function. As we concatenated Q with the formula, we get the result below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!