Rounds a given number down towards zero
The ROUNDDOWN Function is categorized under Excel Math and Trigonometry functions. The function will round down towards zero. Basically, it does the opposite of the ROUNDUP function.
As a financial analyst, this function is useful as it helps round a number and eliminates the least significant digits, simplifying the notation but keeping close to the original value.
The ROUNDDOWN function uses the following arguments:
Now, if the num_digits argument is:
To understand the uses of the ROUNDDOWN function, let’s consider an example:
Suppose we are given the following data:
The results we get in Excel are shown below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to the Excel ROUNDDOWN function. By taking the time to learn and master these Excel functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources: