excel Excel rounding and precision Using the MROUND function


Example

The Excel function MROUND is used to round a number to an interval other than a power of 10.

These examples show MROUND to the nearest quarter and to the nearest even number.

Starting withMROUND(b,0.25)MROUND(b,2)
23.9319521124.0024
2.7931353882.752
21.9390306422.0022
13.7419373913.7514
16.7704741216.7516
13.0392230213.0014
17.0613289617.0018
16.1174169416.0016
33.4824959233.5034
37.2965668737.2538

A similar result can be obtained using the EVEN and ODD functions which round a number up to the nearest even or odd number respectively.