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:
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:
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:
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.
The following tutorials explain how to perform other common tasks in Excel: