Excel Formulas to Round up the Value to the Nearest 5s ~ Easy Guide!!

So far we have seen how to round up the value that is closest to 1000s/100s/10s in Excel. Sometimes you may need to round the numbers to the nearest 5s/10s/15s and so on. So here, we will guide you to learn the quick tricks to solve this work. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• If you need to round a number to the nearest multiple of 5, you can use the below formula.

=MROUND(number,5)

Syntax Explanations:

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

• Here, we will enter the input values in Column B.
• Now we are going to round these values to the nearest multiple of 5.

• 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, you can get to know how to round the values to the nearest 5s in Excel. Hope you like it. Mention your queries in the comment box below. Thank you. Click here to know more about *Geek Excel **and Excel Formulas *!! **

Related Articles:

• Excel Formulas to Round Time to the Nearest 15 Minutes!!
• Excel Formulas to Set the Rank with Ordinal Suffix ~ {Easy Method}
• Formulas to specify the Rank for Racing Result ~ Quick Tricks!!
• Excel Formulas to Round a Number to Down with ROUNDDOWN Function