For example, if a certain number of parts are required to make a single product, you can use MROUND to calculate the number of products that can be made.

## Syntax

`MROUND(Number to round [, Multiple to round to] [, Rounding direction])`

## Arguments

Argument | Data type | Description |

Number to round (required) | Number | The number to round. |

Multiple to round to | Number | The multiple to round to. Using 0 returns a value of NaN (Not a Number). |

Rounding direction | Keyword | The direction to round in. The keywords are UP, DOWN, NEAREST, TOWARDSZERO, and AWAYFROMZERO. There's more information below. |

The MROUND function returns a numeric result.

### Rounding direction keywords

Keyword | Description |

UP | Rounds the value of the This behavior is different to the Excel function ROUNDUP, which rounds away from zero. |

DOWN | Rounds the value of the This behavior is different to the Excel function ROUNDDOWN, which rounds towards zero. |

NEAREST | The default keyword if you omit the Rounds the value of the |

TOWARDSZERO | Rounds the value of the Number to round argument towards zero. |

AWAYFROMZERO | Rounds the value of the Number to round argument away from zero. |

## Syntax example

`MROUND(Product components, 4, Down) / 4`

In this example the total number of *Product components* rounds down to the nearest multiple of four, and then divides by four. In this hypothetical example, four components are required to create a single product. As such, this formula provides the total number of products that can be made with the current number of product components.

## Excel equivalent

## Related Anaplan functions

## Examples

Formula | Description | Result |

MROUND(1234.56) | Only the value to be rounded, 1234.56, has been provided. The formula uses the default arguments of 0 decimal places and the NEAREST direction. | 1,235 |

MROUND(1234.56, 10) | Rounds 1234.56 to the nearest multiple of 10. The formula contains no rounding direction, so the default NEAREST direction is used. | 1,230 |

MROUND(1236.54, 10, TOWARDSZERO) | Rounds 1236.54 to a multiple of 10. The formula uses the TOWARDSZERO rounding direction, so 1236.54, a positive number, was rounded down. | 1,230 |

MROUND(1234.56, 10, AWAYFROMZERO) | Rounds 1234.56 to the nearest multiple of 10. The formula uses the AWAYFROMZERO rounding direction, so 1234.56, a positive number, was rounded up. | 1,240 |

MROUND(1234.56, 1000) | Rounds 1234.56 to the nearest multiple of 1,000. The formula contains no rounding direction, so the default NEAREST direction is used. | 1,000 |

MROUND(-1234.56, 1000, UP) | Rounds -1234.56 to a multiple of 1,000. The formula uses the UP rounding direction, so x rounds towards positive infinity. | -1,000 |

MROUND(-1234.56, 1000, DOWN) | Rounds -1234.56 to a multiple of 1,000. The formula uses the DOWN rounding direction, so x rounds towards negative infinity. | -2,000 |

MROUND(15555, 10, NEAREST) | Rounds 15555 to the nearest multiple of 10. The formula contains no rounding direction, so the default NEAREST direction is used. As 55 is a positive number halfway between 50 and 60, x rounds up, towards positive infinity. | 15,560 |

MROUND(-15555, 10, NEAREST) | Rounds -15555 to the nearest multiple of 10. The formula contains no rounding direction, so the default NEAREST direction is used. As -55 is a negative number halfway between -50 and -60, x rounds down, towards negative infinity. | -15,560 |