How to Use Excel ROUNDUP Function in Office 365?
Tags: excelfunctions, excelroundupfunction
Published: 2020-08-27 11:02:07

---
title: How to Use Excel ROUNDUP Function in Office 365?
published: true
date: 2020-08-27 07:34:53 UTC
tags: ExcelFunctions,ExcelROUNDUPFunction
canonical_url: https://geekexcel.com/how-to-use-excel-roundup-function-in-office-365/
---

## Excel ROUNDUP Function:

![ROUNDUP Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/ROUNDUP-Function.png)<figcaption id="caption-attachment-12699">ROUNDUP Function</figcaption>

This article describes the usage of **Excel ROUNDUP Function in Office 365** with its syntax, description, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **ROUNDUP Function – Description:**

- This function **rounds a number up to the specified number of digits away from zero**.
- For example, **ROUNDUP(4.1234, 3)** returns the output as **4.124**

## **Syntax:**

**=ROUNDUP(number, num\_digits)**

### Argument Explanation:

**Number ** – The input number that needs to be rounded.

**Num\_digits ** – The number of digits by which you want to round the given number.

If the **Digit value is positive** , then it will round the value to the **right of the decimal number**. If the **Digit value is negative** and then it will round the value to the **left of the decimal number**. Kindly refer to the **Digit Value and its Behavior Table**.

| Digit Value | Result of ROUNDDOWN Function |
| --- | --- |
| **>0** | This function will round down the nearest value “ **0.1, 0.01, 0.001, 0.0001** “ |
| **0** | This function will round down to the nearest Whole number ( **1** ) |
| **<0** | This function will round down the nearest value “ **10, 100, 1000, 10000** “ |

HINTS: 
- If num\_digits is **greater than 0** , It will round up the number to the specified number of decimal places.
- It will round up the number to the nearest integer if **num\_digits is 0**.
- If **num\_digits is less than 0** and then it will round up the number to the left of the decimal point.

### Note:

- If any argument is a non-numeric value such as letters, special characters and then it will return **#VALUE!** Error.

## **Examples:**

Let’s see some examples to understand how it works.

### Example 1:

- Refer to the below screenshot.
- The input numbers are listed in **Column A** , its num\_digits are specified in **Column B**.
- Then, the rounded output values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-83.png)<figcaption id="caption-attachment-12693">Example 1</figcaption>

### Example 2:

- If any argument is a non-numeric value such as letters, special characters and then it will return **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-68.png)<figcaption id="caption-attachment-12694">Example 2</figcaption>

## **Wrap-Up:**

I hope, this article helped you to understand the usage of **Excel ROUNDUP Function in Office 365** with its syntax, description, and examples. Give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Related Articles:

- **ROUND Function**
- **ROUNDUP Function**

### See Also:

- [How to Use Excel CEILING.PRECISE Function in Office 365?](https://geekexcel.com/how-to-use-excel-ceiling-precise-function-in-office-365/)
- [How to Use Excel QUOTIENT Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-quotient-function-in-office-365-with-examples/)