# MROUND

## Content

This function returns a number rounded to the desired multiple.

## Syntax

`MROUND(number, multiple)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *number* | <span data-teams="true">[</span>Required<span data-teams="true">] </span>Numeric value to round |
| *multiple* | <span data-teams="true">[</span>Required<span data-teams="true">] </span>Numeric value representing the rounded result |

## Remarks

This function rounds to the nearest multiple (either up or down). For even numbers where there may be two choices (one rounding up and one rounding down), the result is the number farther from zero. For example, MROUND(18,4) returns 20 even though 16 is as near since 20 is farther from zero. For MROUND(-18,-4) returns -20 since that value is farther from zero.

## Examples

`MROUND(B14,3)`
`MROUND(R14C2,5)`
`MROUND(100,8)` gives the result 104
`MROUND(11,8)` gives the result 8
`MROUND(12,8)` gives the result 16
`MROUND(13,8)` gives the result 16
`MROUND(-12,-8)` gives the result -16
`MROUND(50,8)` gives the result 48
`MROUND(-50,-8)` gives the result -48