# Roundup 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.