> ## Documentation Index
> Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MRound

Rounds the number down to the closest multiple of the specified number

**Category:** `math`

**Syntax:**

```
MRound([number], multiple)
```

**Returns:** `Number`

**Context Filtering:** ✓ Yes

## Parameters

| Name       | Type               | Required | Description                         |
| ---------- | ------------------ | -------- | ----------------------------------- |
| `number`   | `number or column` | ✓ Yes    | The number to be rounded            |
| `multiple` | `number`           | ✗ No     | The multiple to round the number to |

**Allowed Column Types for `number`:** INT, FLOAT, DECIMAL

## Validation

* Minimum parameters: 1
* Maximum parameters: 2

## Examples

```
MRound([Number])
```

Rounds the Number column by a factor of 1 because no argument is passed. This is equivalent to the result of the factor of (-1).

```
MRound([Cost], 5)
```

Rounds each value in the Cost column to the nearest multiple of 5

```
MRound(23, 5)
```

Returns 25
**Result:** `25`

```
MRound(27, 5)
```

Returns 25
**Result:** `25`

```
MRound(23, -5)
```

Returns 25 (negative factor sign is ignored)
**Result:** `25`