Roundup Excel

This article outlines everything you need to know about to round a number up in Excel.

How to round up in Excel

For anyone who performs financial analysis in Excel it can frequently be important to roundup a number to a specific decimal place or to a whole number.

In this session we will show you how to round a number up in Excel using the =ROUNDUP() function.

This formula will be a major help in saving you time when performing financial modeling and will also improve your accuracy in Excel.

How the function works

The Excel roundup formula asks you to reference a specific number and then indicate how many units (decimal places) you want to round it to.

=ROUNDUP()

In this example we show you how to create a table that uses the roundup formula to link to a number and then return a certain number of decimal places.

Step 1: type “=ROUNDUP(“

Step 2: link to the cell you want to round down and add a comma

Step 3: type the number of units, or link to a cell that contains the number of units you want to display

Step 4: close bracket and press enter.

See the screenshot below for an example of the “roundup” function in action.

Download the Excel template.

More CFI Excel resources

If you want to become an Excel power user please check out our Excel Resources to learn all the most important functions, formulas, shortcuts, tips and tricks.