# How to Use Excel ROUNDUP Function?

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 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.

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 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.