Excel Formulas to Round Number Down to Nearest Multiple Value!!

In the previous post, we have learned how to round a number down in Excel. Likewise, here we will guide you to round a number down to the nearest specified multiple 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:

• If you want to round a number down to the nearest multiple values in Excel, use the below formula.

=FLOOR(number,multiple)

Syntax Explanations:

• FLOOR – In Excel, the FLOOR function will help to round a number down to the nearest multiple of significance.
• Number – It represents the input values from your worksheet.
• Multiple – It specifies the nearest multiple values.
• 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.

Example:

Refer to the below example image.

• First, we will enter the input values in Column B.
• Now we are going to round these input values by the nearest multiple values 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 tutorial, we have explained the simple formulas to round a number down to the nearest specified multiple in Excel. Hope you like it. Mention your queries in the below comment box. 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!!
• How to Round Cell Values without Formulas in Excel Office 365?
• Excel Formulas to Get Integer Part of a number ~ Quick Tricks!!