> 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

```sigma
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).

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

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/e0e64d755eafd2edaf4cfbafa5ea2ecde1f27769889e8603df9af045b78e3871/assets/docs-images/d9eb5d4-1.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20261007%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20261007T071715Z&X-Amz-Expires=604800&X-Amz-Signature=4af5bb5e1c1e8a859c2e03beb9ec6cd3dabec7100552a1a0e8e30e11250fe8c5&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

(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.

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

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/d7342c6e6b266244a673e790543182014bcb0959932a1dd2c670ea090ee8a280/assets/docs-images/63b93f6-2.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20261007%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20261007T071715Z&X-Amz-Expires=604800&X-Amz-Signature=5757709d15413b475561cda62ae1435410ef52f89d49e2aed1f2a6dd1bcdfa66&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

(3) Returns 500.

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

## Related resources

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