# How to Use Excel ROUNDDOWN Function?

Excel is a spreadsheet developed by Microsoft. This application will help you to create, view, edit, and share your files with others as soon as possible. It also provides numerous formulas and functions to do mathematical calculations, graphic tools, pivot tables, charts, etc.

Sometimes, you want to round down a large set of numbers. Instead of doing it manually, you can quickly finish this task with the help of the Excel ROUNDDOWN Function. It will round a number down to the specified number of digits towards zero.

In this post, we are going to learn how to use Excel ROUNDDOWN Function 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

## Definition of ROUNDDOWN Function

• It is one of the built-in functions in Microsoft Excel.
• This function rounds a number down to the specified number of digits toward zero.
• For example, ROUNDDOWN(1.2345, 3) will return the output value of 1.234

## Syntax

• Here, you will see the syntax of the ROUNDDOWN function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=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.

Note:
1) If num_digits is greater than 0, It will round down (towards zero) the number to the specified number of decimal places.
2) It will round down the number to the nearest integer if num_digits is 0.
3) If num_digits is less than 0 and then it will round down the number to the left of the decimal point.
4) If any argument is a non-numeric value such as letters, special characters and then it will return #VALUE! Error.

## Excel ROUNDDOWN Function

Here, we have given some examples for your reference.

• The input numbers are given in Column B, and the digits are specified in Column C.
• Apply the above-mentioned formula. Then, the rounded-down values are listed in Column C.
• Finally, we need to click on the button to get the result. Drag-down the first cell to fill the remaining cells.

## Input that Causes Error

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

## Verdict

In this post, you can clearly understand the usage of the Excel ROUNDDOWN Function with its syntax, definition, and examples. Leave your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to use the Excel ROUNDDOWN function in the spreadsheet.