Excel Formulas to Round a Number to the Nearest Multiple Values!!

Rounding a number to the nearest integer or the nearest multiple is a common task for many people. There are a couple of great functions in Excel that allows you to quickly round the value. In this article, I will show you how to round a number to the nearest multiple values. This nearest value can be less than or greater than the given input based on the criteria. Let’s see them below!! 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 to the nearest multiple values in Excel, use the below formula.

=MROUND(number,multiple)

Syntax Explanations:

• MROUND – In Excel, the MROUND function will help to return a number rounded to the given multiple.
• Number – It represents the input values from your worksheet.
• Multiple – It specifies the 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.

Practical Example:

Refer to the below example image.

• First, we will enter the input values in Column B.
• Now we are going to round the value based on specified 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.

Wind-Up:

Hope you like this article on how to round a number to the nearest multiple values in Excel? If you feel this article is useful, then leave feedback 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 to N Significant Digits!!
• Excel Formulas to Round Number Down to Nearest Multiple Value!!