# How To Use Excel Round Down Function

Excel round down is a function to round numbers. This step by step guide on how to round down a number in Excel is useful for financial analysts.

Learn how you can easily round down a number in Excel using a simple function.

This article focuses on using the ROUNDDOWN formula in Microsoft Excel. The function returns the specified number rounded down to a given number of places. What makes it useful is its unique properties. This function is different from standard rounding, as it rounds all numbers down.

For example, only numbers below 5 are rounded down in regular rounding, and values higher than 5 are rounded up. With ROUNDDOWN, all numbers are always rounded down. This may be useful in several scenarios.

## What is the ROUNDDOWN formula in Excel?

### Description

This formula rounds a number down, toward zero.

### Syntax

=ROUNDDOWN(number, num_digits)

### Arguments

• number - The number you want to round down.
• num_digits - The number of digits to which your specified number should be rounded down.

## How to use the ROUNDDOWN formula in Excel

This section focuses on how to use the round down function in Microsoft Excel. The steps below were written using the latest Microsoft Excel 2019 for Windows 10. Don’t worry — the guide works even if you’re currently using a different version or platform.

We've set up an example table that uses the ROUNDDOWN formula to link one number, and then return a specific number of decimal places.

1. Launch Microsoft Excel and open the relevant document you want to work with or create a new one.
2. Select an output cell.
3. Type in the following formula: =ROUNDDOWN(number,digits). For example, if you wanted to round down the number 53.47364 to 5 digits, you’d type in =ROUNDDOWN(53.47364,5).

4. Alternatively, you can reference cells in the formula. For example, if you want to round down the value in C4 with the value in E6, you can use the =ROUNDDOWN(C4,E6) formula.
5. You may also mix and match cells and numbers. For example, you can round down any cell value with a number, and vice versa.

### Final thoughts

We hope this article helped you learn how to use the ROUNDDOWN function in Excel, allowing you to round down numbers with ease. This knowledge may help you perform calculations easier and faster when working with spreadsheets requiring mathematics.

### Before you go

If you need further help with Excel, don’t hesitate to contact our customer service team, available 24/7 to assist you. Return to us for more informative articles all related to productivity and modern-day technology!