Often you may want to round values to the nearest .25 in Excel.

For example, you may want to:

- Round
**1.23**to**1.25**. - Round
**2.12**to**2**. - Round
**3.83**to**3.75**.

And so on.

You can use the following formula to do so:

**=MROUND(A1, 0.25)
**

This particular formula rounds the value in cell **A1** to the nearest multiple of **0.25**.

The following example shows how to use this formula in practice.

**Example: Round to Nearest .25 in Excel**

Suppose we have the following list of values in Excel:

Suppose we would like to round each value in the list to the nearest **0.25**.

We can type the following formula in cell **B2** to do so:

**=MROUND(A2, 0.25)**

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays each of the values in column A rounded to the nearest **0.25**.

Note that if you use the **MROUND** function with negative numbers, the multiply you round to must also be negative for the formula to work correctly.

Fortunately, you can use the following formula to multiply the value in the **MROUND** function by the **SIGN** of the cell you’re rounding:

**=MROUND(A2, SIGN(A2)*0.25)**

The following screenshot shows how to use this formula in practice:

Notice that column B now displays each of the values in column A rounded to the nearest **0.25** and no errors are produced since we used the **SIGN** function within the **MROUND** formula.

**Note**: You can find the complete documentation for the **MROUND** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Round to Significant Figures in Excel

How to Find the Top 10 Values in a List in Excel

How to Find the Top 10% of Values in Excel