Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
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.
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 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.
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.
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.
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.
Microsoft. (n.d.). ROUNDUP function. Retrieved January 5, 2020, from https://support.office.com/en-us/article/roundup-function-f8bc9b23-e795-47db-8703-db171d0c42a7.
More Articles on Excel Functions
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