How To Use Excel Round Down Function

Rick Akura on
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.

use excel rundown fucntion

 

Table of Contents 

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).
    use excel rundown function

    Imgur link
  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.
    use excel rundown function
    Imgur link
  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!

Would you like to receive promotions, deals, and discounts to get our products for the best price? Don’t forget to subscribe to our newsletter by entering your email address below! Receive the latest technology news in your inbox and be the first to read our tips to become more productive.

You may also like

» How to Freeze a Row or Column in Excel for Mac
» How to Separate First and Last Name in Excel
» How To Use the Excel Data Analysis ToolPak

Tags: Product guides