Microsoft Excel Functions & Formulas

Use the MROUND function to round values to

the nearest multiple of 10 or 50

Sometimes it is necessary to round up values to the nearest multi-

ple of 10 or 50. To perform this task, use the MROUND function

from the Analysis ToolPak add-in. MROUND returns a number

rounded to the desired specified multiple.

4

To round values to the nearest multiple of 10 or 50:

1. In cells A2:A10 list any kind of values.

2. Select cells B2:B10 and type the following formula:

=MROUND(A2,10).

3. Press <Ctrl+Enter>.

4. Select cells C2:C10 and type the following formula:

=MROUND(A2,50).

5. Press <Ctrl+Enter>.

Note: To use this function, you need to have the Analysis

ToolPak installed ...