How to Use “Excel ROUNDDOWN Function” in Office 365?
Tags: excelfunctions, excelrounddownfuncti
Published: 2020-08-27 11:01:56

---
title: How to Use “Excel ROUNDDOWN Function” in Office 365?
published: true
date: 2020-08-27 07:30:52 UTC
tags: ExcelFunctions,ExcelROUNDDOWNFuncti
canonical_url: https://geekexcel.com/how-to-use-excel-rounddown-function-in-office-365/
---

## Excel ROUNDDOWN Function:

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

In this post, we are going to learn how to use **Excel ROUNDDOWN Function in Office 365** with its syntax, definition, and examples. 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)

## **ROUNDDOWN Function – Definition:**

- This function **rounds a number down to the specified number of digits** towards zero.
- For example, **ROUNDDOWN(1.2345, 3)** will return the output value as **1.234**

## **Syntax:**

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

### Argument Explanation:

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

**Num\_digits ** – The number of digits by which the input number should be rounded.

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 down ( **towards zero** ) the number to the specified number of decimal places.
- It will round down the number to the nearest integer if **num\_digits is 0**.
- If **num\_digits is less than 0** and then it will round down 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:**

Here, we have given some examples for your reference.

### Example 1:

- Refer to the below screenshot.
- The input numbers are given in **Column A** , its digits are specified in **Column B**.
- Then, the rounded down values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-82.png)<figcaption id="caption-attachment-12685">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-67.png)<figcaption id="caption-attachment-12686">Example 2</figcaption>

## **Verdict:**

In this post, you can clearly understand the usage of **Excel ROUNDDOWN Function in Office 365** with its syntax, definition, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Related Articles:

- [**MROUND Function**](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/)
- [**CEILING Function**](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/)
- **ROUNDUP Function**

### Read Ahead:

- [How to Use Excel POWER Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-power-function-in-office-365-with-examples/)
- [How to Use Excel ROMAN Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-roman-function-in-office-365-with-examples/)