Excel ROUNDUP Function: Sometimes, we want to round the values given in the spreadsheet, doing this manually will take a lot of time. So, we come up with the built-in Excel function called “ROUNDUP”, which helps to do that as quickly as possible. We all know that Excel functions will make our work easy and simple.
This article describes the usage of the Excel ROUNDUP Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Description of ROUNDUP Function
- It is one of the built-in functions in Microsoft Excel.
- This function rounds a number up to the specified number of digits away from zero.
- For example, ROUNDUP(4.1234, 3) returns the output as 4.124
Syntax
- Here, you will see the syntax of the ROUNDUP function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
=ROUNDUP(number, num_digits)
Argument Explanation:
- Number – The input number that needs to be rounded.
- Num_digits – The number of digits by which you want to round the given number.
- If the Digit value is positive, then it will round the value to the right of the decimal number. If the Digit value is negative and then it will round the value to the left of the decimal number. Kindly refer to the Digit Value and its Behavior Table.
| Digit Value | Result of ROUNDUP Function |
|---|---|
| >0 | This function will round down the nearest value “0.1, 0.01, 0.001, 0.0001“ |
| 0 | This function will round down to the nearest Whole number (1) |
| <0 | This function will round down the nearest value “10, 100, 1000, 10000“ |
Note:
1) If num_digits is greater than 0, It will round up the number to the specified number of decimal places.
2) It will round up the number to the nearest integer if num_digits is 0.
3) If num_digits is less than 0 and then it will round up the number to the left of the decimal point.
4) If any argument is a non-numeric value such as letters, or special characters and then it will return #VALUE! Error.
Examples
Let’s see some examples to understand how it works.
- The input numbers are given in Column B, and the digits are specified in Column C.
- Apply the above-mentioned formula. Then, the rounded-up values are listed in Column C.
- Finally, we need to click on the Enter button to get the result. Drag-down the first cell to fill the remaining cells.
- If any argument is a non-numeric value such as letters, or special characters and then it will return #VALUE! Error.
Wrap-Up
I hope, this article helped you to understand the usage of the Excel ROUNDUP Function with its syntax, description, and examples. Give your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
The following video will show you how to use the Excel ROUNDUP function in the spreadsheet.
See Also:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.
