Skip to main content

How to Use the ROUNDUP Function in Excel

Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.

Here in the illustration the ROUNDUP function is used to round up a number to one decimal place value.

Here in the illustration the ROUNDUP function is used to round up a number to one decimal place value.

The Purpose of the ROUNDUP Function

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

An alternative to the roundup function may be using changing for format of a cell to reflect the amount of decimal places needed. But, in another circumstance, this function may be needed to round only a variable within a calculation.

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

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

Rounding Up One Reference

One of 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 will be rounded to the first decimal place in the cell where the formula stands.

Rounding up individual references

Rounding up individual references

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.

Rounding up individual numbers

Rounding up individual numbers

Rounding up eexpressions

Rounding up eexpressions

Inserting the ROUNDUP Function

The ROUNDUP function must be added to a cell as a formula. When manually adding this function to a cell the cell must and clicked and "AVERAGE(" needs to be typed. After the open parenthesis, a number or cell reference need to be added followed by a comma and a number that represents how many decimal places the number needs to be rounded to. Finally, a close parenthesis is added and the data can be entered.

Scroll to Continue

The ROUNDUP function can also be inserted into a cell. To use this method a cell is first selected. Next, the formulas tab must be selected followed by selecting the "math & Trig" button from the function library. Next, select ROUNDUP from the drop down menu. These first few steps are shown in the illustration below.

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

After the the functions arguments window appears, a cell reference can either be typed in or selected from the worksheet by clicking on the up arrow to the right of the value field.

Notice the reference under the value field. This reference indicates what value will be returned depending on what type of data is referenced. Once the reference is entered into the value field, a preview of of the number that will be displayed will appear in the bottom left-hand corner of this window. Additionally, any data can be entered into the values field to see what type of data it is.

After the reference is selected, click on the OK button.

The Functional Arguments window provides fields where you can enter arguments of a function with the help of tip given when the cursor is in selected fields.

The Functional Arguments window provides fields where you can enter arguments of a function with the help of tip given when the cursor is in selected fields.

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