> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# MRound

> Rounds the input number to the closest multiple of the given factor.

Rounds the input number to the closest multiple of the given factor.

## Usage

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

**number** (required) The number to be rounded.

**factor** \[optional] The multiple to which the number will be rounded. The positive or negative sign of the factor is not considered. This value cannot be 0. The default value is 1.

## Examples

(1) 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([Number])
```

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/e0e64d755eafd2edaf4cfbafa5ea2ecde1f27769889e8603df9af045b78e3871/assets/docs-images/d9eb5d4-1.png)

(2) Rounds the value for each row in the input column to a multiple of 50. The positive or negative sign of the factor (-50) is not considered. As such, they return the same result.

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

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/d7342c6e6b266244a673e790543182014bcb0959932a1dd2c670ea090ee8a280/assets/docs-images/63b93f6-2.png)

(3) Returns 500. 

```
MRound(-456, 100)
```

## Related resources

* [Round](/docs/round)
* [Ceiling](/docs/ceiling)
* [Floor](/docs/floor)