- Excel Tutorial
- Excel Introduction
- Excel Addition(+)
- Excel Subtraction(-)
- Multiplication(*)
- Excel Division(/)
- Excel IF Function
- Excel SUMIF
- Count & CountIF
- Excel IFerror
- Excel Pivot Table
- Move Pivot Tables
- Excel Drop-Down list
- Conditional Formatting
- Excel Hyperlink
- Excel Vlookup
- Excel Hlookup
- Excel Protect Sheet
- Excel Macros
- Excel Insert Images
- Excel Concatenate
- Excel Text To Column
- Remove Duplicates
- Excel Cell Formatting
- Group in Excel
- Excel Comments
- Excel Freeze Panes
- Excel Charts
- Print in Excel
- Excel Transpose
- Reminders in Excel
- Reduce Excel File Size
- Percentage in Excel
- Substitute Function
- RANK Function
- ROUND Function
- Cell References
- Date Function
- Text Functions
- Percentage Calculation
- Text to Columns
- Rounddown in Excel

EXCEL FORMULAS Excel Tutorial Excel Introduction Excel Addition(+) Excel Subtraction(-) Multiplication(*) Excel Division(/) Excel IF Function Excel SUMIF Count & CountIF Excel IFerror Excel Pivot Table Move Pivot Tables Excel Drop-Down list Conditional Formatting Excel Hyperlink Excel Vlookup Excel Hlookup Excel Protect Sheet Excel Macros Excel Insert Images Excel Concatenate Excel Text To Column Remove Duplicates Excel Cell Formatting Group in Excel Excel Comments Excel Freeze Panes Excel Charts Print In Excel Excel Transpose Reminders in Excel Reduce Excel File Size Percentage in Excel Substitute Function RANK Function ROUND Function Cell References Date Function Text Functions Percentage Calculation Text to Columns Rounddown in Excel

Rounddown Function | Syntax | How to Use | Examples

Have you ever had to round down a number in Excel for a large dataset manually? But **how to do a rounddown function in Excel?** Believe it or not, Microsoft Excel would make this function much easier.

So, without further ado, let’s take a look at how you can create round downs in your spreadsheets using the Rounddown function.

The ROUNDDOWN function in Excel rounds a number down to a specific number of decimal places, taking it down to the next valid increment.

ROUNDDOWN(number, num_of_digits)

Where:

- Number: is the number that should be rounded.
- Num-of-digits: indicates how many places the decimal place or place value should round down to.

=ROUNDDOWN(number,num_of_digits)

The ROUNDDOWN function shows the last decimal digit as it is, without rounding up any digit that comes after.

We understand it can be a little confusing, so let us take up a couple of examples of how this goes

A ROUNDDOWN function can be used in 3 ways:

Let us consider an example for each scenario.

Let us consider a dataset as shown in the image below.

Since we are rounding down all numbers to zero decimal place, num_of_digits for all the numbers will be 0.

Once you open the ROUNDDOWN function, a dialog box appears as shown below.

2. Enter the cell numbers in the number & num_of_digits box as shown in the image. Alternately, you can add the decimal value directly to num_digits.

3. The resulting number in the C2 cell will be rounded to 0 decimal places.

4. Use CTRL + D to copy the formula from the first cell to the last cell.

Let us consider the same dataset as in example 1 and change the decimal points to numbers as shown in the image below.

Repeat the same procedure using the =ROUNDDOWN(B2,C2) formula, and you can find the decimal points rounded down to the numbers as shown.

Previously, we discussed that a negative value for num_of_digits rounds down the digit to the left of decimal places.

Let us consider the following example.

Using the same formula, we can see the numbers rounded to the left of the decimal point.

We hope this article was helpful to you.

- How to do Vlookup in Excel?
- How to find Percentage in Excel?
- Group and Un-Group in Excel.
- Multiple Types of Addition in Excel.
- How to use PivotTable in Excel?

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

3 Comments

loveawake.ru says: Welcome to the world of adult Dating loveawake.ru |

loveawake.ru says: Welcome to the world of adult Dating loveawake.ru |

fazi g says: hi |

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.