An Overview of ROUNDUP Function | Microsoft Excel

The ROUNDUP function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the ROUNDUP function in Excel.

Objectives

The ROUNDUP function is used to round up a numerical value to a specific decimal place.

Syntax

=ROUNDUP(number, num_digits)

Arguments

  • number: It refers to the number to round up.
  • num_digits: The total number of digits that you want after the decimal point.

Output

A rounded-up version of the input number.

Examples of ROUNDUP Function

Suppose, you have the number 65.543275 in cell A2. You can round up the number to any number using the ROUNDUP function. Suppose, you want to round up 65.543275 to 2 decimal places. For that, use the formula:

=ROUNDUP(A2,2)

The output will be 65.55.

Here are some examples of the usage of the ROUNDUP function.

Examples of ROUNDUP Function in Excel

Usage Guide of ROUNDUP Function

Step_1: Start with inserting an equal sign (=) in a blank cell.

Step_2: Then type ROUNDUP.

Step_3: Type open parenthesis “(“.

As you type the open parenthesis, Excel shows the syntax of the ROUNDUP function.

Step_4: Insert a number to round up.

You can directly insert a number or a cell address that contains a number.

Step_5: Then insert a comma (,).

After inserting the comma, Excel will ask you for the second argument which is the number of digits.

Usage Guide of ROUNDUP Function in Excel

Step_6: Now specify the number of digits that you want after the decimal point.

I want to round up the number to 2 decimal places. So, I have inserted 2 inside the function.

Usage Guide of ROUNDUP Function in Excel

Final Result

The ROUNDUP function converts 65.553275 into 65.56. Because here, num_digits is 2 which allows only 2 decimal places after the decimal point.

Availability

  • Excel for Microsoft 365
  • Excel 2016
  • Excel for Microsoft 365 for Mac
  • Excel 2016 for Mac
  • Excel for the web
  • Excel 2013
  • Excel 2021
  • Excel 2010
  • Excel 2021 for Mac
  • Excel 2007
  • Excel 2019
  • Excel for Mac 2011
  • Excel 2019 for Mac
  • Excel Starter 2010

Remarks

  • The ROUNDUP function shows #VALUE! error in the case of non-numeric values.
  • When a number is already rounded down, the ROUNDUP function doesn’t work.

Related Rounding Functions

  • ROUND Function rounds to the given number of decimal places.
  • MROUND Functionrounds to the nearest specified multiple.
  • ROUNDDOWN Functionrounds down a numerical value to a specific decimal place.
  • CEILING Functionrounds up a numerical value to the nearest integer or the nearest multiple of significance.
  • FLOOR Function rounds down a numerical value to the nearest multiple of significance.
  • INT Functionrounds down a numerical value to the nearest integer number.
  • TRUNC Functionremoves specific digits from the fraction part of a number.

Conclusion

The ROUNDUP function is one of the math and trigonometry functions in Excel. If you have any questions regarding the ROUNDUP function, please comment below. Thanks!

(Visited 47 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *