Excel Formulas to Round up the Value to the Nearest 5s ~ Easy Guide!!
Tags: excelformula, excelformulas
Published: 2021-04-28 06:38:56

---
title: Excel Formulas to Round up the Value to the Nearest 5s ~ Easy Guide!!
published: true
date: 2021-04-24 07:08:26 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-round-nearest-5s/
---

So far we have seen how to **[round up the value that is closest to 1000s/100s/10s in Excel](https://geekexcel.com/excel-formulas-round-numbers-nearest-1000s/)**. 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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Round the values to the nearest 5s](https://geekexcel.com/wp-content/uploads/2021/04/Round-the-values-to-the-nearest-5s.png)](https://geekexcel.com/excel-formulas-to-round-nearest-5s/round-the-values-to-the-nearest-5s/#main)<figcaption id="caption-attachment-34780">Round the values to the nearest 5s</figcaption>

## General Formula:

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

**=[MROUND](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/)(number,5)**

## Syntax Explanations:

- **MROUND**  – The [**MROUND function**](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/) 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.

[![Input Values](https://geekexcel.com/wp-content/uploads/2021/04/Input-Values.png)](https://geekexcel.com/excel-formulas-to-round-nearest-5s/input-values-2/#main)<figcaption id="caption-attachment-34782">Input Values</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-21.png)<figcaption id="caption-attachment-34781">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-31.png)<figcaption id="caption-attachment-34783">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Round Time to the Nearest 15 Minutes!!](https://geekexcel.com/excel-formulas-to-round-time-to-the-nearest-15-minutes/)**
- **[Excel Formulas to Set the Rank with Ordinal Suffix ~ {Easy Method}](https://geekexcel.com/excel-formulas-to-set-the-rank-with-ordinal-suffix-easy-method/)**
- **[Formulas to specify the Rank for Racing Result ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-specify-the-rank-for-racing-result-quick-tricks/)**
- **[Excel Formulas to Round a Number to Down with ROUNDDOWN Function](https://geekexcel.com/excel-formulas-to-round-a-number-down/)**