Excel Formulas to Round a Number to Down with ROUNDDOWN Function

When performing financial analysis in Excel it’s often useful to round down a number to either a decimal place or a whole number. The Excel ROUNDDOWN function helps to complete this task easily, even for a large dataset. In this article, we will show you how to round a number down in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• Use the below formula for numbers to round down, regardless of its value.

=ROUNDDOWN(number,digits)

Syntax Explanations:

• ROUND – In Excel, the ROUNDDOWN function will help to round a number down to the specified number of digits towards zero.
• Number – It represents the input values from your worksheet.
• Digits – This is the value that specifies how many digits to be rounded.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

• First, we will enter the input values in Column B.
• Here, we need to round down the numbers based on the digits which are given in Column C.

• So, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, we will get the result in the selected cell.

Verdict:

From this chapter, we have described the simple formula to round a number down in Excel. If you have any questions, feel free to comment. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **

Read Also:

• Excel Formulas to Round a Number ~ A Complete Tutorial!!
• Formulas to Set the Rank with Ordinal Suffix ~ {Easy Method}
• Excel Formulas to Highlight the Entire Rows Between Two Dates!!