Microsoft Excel has provided a number of very easy, quick & useful methods to round up the decimals to a particular point or limit. In this article, Iâ€™ll illustrate how you can use those simple techniques to round up decimals within seconds.

**Table of Contents**hide

**Download Practice Workbook**

You can download the Practice Workbook weâ€™ve used to prepare this article. You can change the data to see the results with rounded-up values. Or even you can embed the formulas to find out results with random data given in the spreadsheets.

**4 Quick & Simple Methods to Round up Decimals in Excel**

In our dataset, we have 4 different numbers with decimals & we want to round up the decimals to a particular point.

**1. Customizing Number Format to Round up Decimals**

We can directly customize the number format to round up the decimals. Itâ€™ll not round *up* every time however based on the decimal values. If the decimal value is 5 or more than 5, only then the preceding value will be added with 1.

**Read More:** Excel Custom Number Format Multiple Conditions

For example, 163.425 will be 163.43 when we want 2 decimal places. If we want only 1 decimal place for that number, itâ€™ll become 163.4, not 163.5 as the following digit after 4 is 2.

**Related:** Excel Round to 2 Decimal Places (with Calculator)

To customize this number format we have to do the following steps.

âž¤ Select the number or a range of cells containing numbers.

âž¤ Under the **Home** & from the **Number** group of commands, select the Expansion flag.

âž¤ Go to the **Number** category from the list.

âž¤ Type the decimal places you want & the sample result will be shown on the top of it.

âž¤ Press **Ok** & youâ€™re done.

**2. Using Math & Trig Drop-down to Round up an Array of Decimals**

We can select the **ROUNDUP** function from the Formulas tab & itâ€™ll let you choose an array or a large range of cells with more precision.

**Steps:**

âž¤ Go to the **Formulas** ribbon first.

âž¤ From the **Math & Trig** drop-down, select the ROUNDUP command. A dialogue box named **Function Arguments** will appear.

âž¤ Now select the cells of numbers that you want to round up.

âž¤ Type 3 or some other value inside the **num_digit** section. Youâ€™ll find a preview of the resultant value at the right bottom of the arguments.

âž¤ Press **OK** & youâ€™ll get the result immediately.

Here Iâ€™ve shown results for all the numbers rounded up to fixed decimal places in the picture below.

**3. Using ROUNDUP Function to Round up Decimals**

We can use the **ROUNDUP** function directly in Excel to round up decimals or numbers. The syntax for this method will be â€“

`=ROUNDUP(Numbers, num_digits)`

In the arguments section,

**Numbers** â€“ Number that we want to round up.

**num_digits** â€“ Decimal point or number place that we want to round up to.

So, for 163.425, if we round up to 3 decimal places then itâ€™ll remain the same as it has exactly **3** decimal places. Rounding up to **2** decimal places will result in 163.43 For **1** decimal place, itâ€™ll be 163.5

If you want to get integers only then you have to use 0 or negative values in the **num_digit** argument.

When weâ€™ll use **0**, the result will be 164 as 0.425 will convert to 1 then itâ€™ll be added with 163 to make 164.

For **-1** as **num_digit**, weâ€™ll get 170 & for** -2**, itâ€™ll turn 200.

**Note:** We can also use the **ROUND** function here but this function will either round up or round down the number based on the following decimal digit. So this function is not recommended if you want to round up only.

**4. Inserting Ceiling Function to Round up to Specified Multiple of Numbers & Decimals**

Now weâ€™ll use the **Ceiling** function to **round off numbers in Excel**. But before that, letâ€™s recognize the role of this function. The **ceilingÂ function** rounds up a number to the nearest multiple of significance. Like, if we round up 163.425 to the nearest multiple of 0.25 then the outcome will be 163.500 and the multiple of 0.25 will assign to the digit right after the decimal point.

The syntax of this function is-

`=CEILING(number, significance)`

In the arguments section,

**number**â€“ The number you want to round up

**significance**â€“ Itâ€™s the number or decimal value that will be multiplied by the integers automatically to round up your number to the next multiple of that value inputted by you.

**Concluding Words**

These are all the most common & fruitful methods to round up decimals or numbers under different criteria. If you think Iâ€™ve missed a formula or technique that I shouldâ€™ve added too, then let me know through your valuable comments. Or you can take a look at our other interesting & informative articles related to Excel functions on this website.

## Further Readings

- Excel 2 Decimal Places without Rounding (4 Efficient Ways)
- Excel Round to Nearest 100 (6 Quickest Ways)
- Excel round to nearest 10000 (5 Easiest Ways)
- How to Round Numbers in Excel Without Formula (3 smart ways)
- Using Excel to Round to Nearest 1000 (7 Easy Ways)
- How to Round Off Numbers in Excel (4 Easy Ways)
- How to Round to Nearest Multiple of 5 in Excel (3 Easy Ways)