Skip to main content

How to Use the ROUNDUP Function in Excel

Joshua earned an MBA from USF and he writes mostly about software and technology.

The Purpose of the ROUNDUP Function

When we round a number up we are essentially increasing or decreasing the decimal place. The ROUNDUP function used in Excel rounds a number up as the name suggests. More specifically, this function can be used to round up to the decimal place that you desire.

An alternative to the roundup function may be to change the format of a cell to reflect the amount of decimal places needed. Let's take a look at an example to see how the function works.

ROUNDUP Function

The ROUNDUP function is used to round up a number to one decimal place.

The ROUNDUP function is used to round up a number to one decimal place.

Rounding Up a Cell

One of the many practical applications for the ROUNDUP function would be to round up a number by referencing that number from another area. In the example below, 2.365 in cell H5 will be rounded to the first decimal place.

Rounding up individual cell references.

Rounding up individual cell references.

Rounding an Array of Cells

The ROUNDUP function allows you to easy round up an array of numbers to the same decimal places. Simply select and array instead of a single cell and the result will display.

The above illustration shows the ROUNDUP function used with an array of data.

The above illustration shows the ROUNDUP function used with an array of data.

Rounding Individual Numbers

You may also round individual numbers with this function. The number plugs right into the formula. You may use this scenario when you want to view the rounded number but want to hide the original number and still be able to reference it in the formula.

how-to-use-the-roundup-function-in-excel

Rounding Calculations

Calculations can also be rounded with this function. The function can have a calculation within it or even round the result of a series of functions.

how-to-use-the-roundup-function-in-excel
Scroll to Continue

Inserting the ROUNDUP Function

Like the examples above the roundup function can be entered manually. Another option would be to insert the function into a cell. While the the function is not very complex, inserting can aid understanding what arguments need to added where until one has more experience using it.

To insert the ROUNDUP function, first select the cell where you would like the results to appear. Next, click in the formulas tab and follow that with the selection of the "math & Trig" button from the function library. Select ROUNDUP from the drop down menu. These first few steps are shown in the illustration below.

Formulas Tab

how-to-use-the-roundup-function-in-excel

After the the functions arguments window appears, a cell reference, array of cell, or number can be added to the number argument field. Cell references and ranges can be selected instead of entered by clicking on the arrow to the right of the field.

The second argument field labeled Num_digits will be the number of decimal places past the whole number that you need the number to be rounded.

After the two arguments are entered the a preview of the result will be displayed in the bottom left-hand corner of the window. Clicking Ok would complete insert the function into the cell that was first selected.

Functional Arguments Window

The Functional Arguments window provides fields where you can enter arguments of a function be be provide with help tips and the final results before entering the function.

The Functional Arguments window provides fields where you can enter arguments of a function be be provide with help tips and the final results before entering the function.

References

Microsoft. (n.d.). ROUNDUP function. Retrieved January 5, 2020, from https://support.office.com/en-us/article/roundup-function-f8bc9b23-e795-47db-8703-db171d0c42a7.

How to Use the COUNT Function in Excel

How to Use the AVERAGE Function in Excel

How to Use the ABS Function in Excel

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2022 Joshua Crowder

Related Articles