---
title: "Use the ROUND Function to Round Numbers to Nearest Value"
slug: "round-function"
description: "Learn to use the ROUND function to round numbers to a specified number of digits in Pigment and simplify your data formatting."
tags: ["formula syntax", "functions ", "Modeling and Formulas", "Pigment Blocks", "Pigment Boards", "ROUND "]
updated: 2025-06-09T10:00:11Z
published: 2025-08-22T10:56:55Z
canonical: "kb.pigment.com/round-function"
---

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

# ROUND function

## ​​​Description

Rounds the first argument to the number of decimal places specified in the second argument.

## Syntax

`ROUND(Number [, Number of Digits])`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Number* (required) | Number | Any Dimensions | Number to round. |
| *Number of Digits* (optional) | Integer or Metric | No Dimension or Dimensions of argument *Number* | Number of decimal places to round to. By default, the argument *Number* is rounded to the nearest integer value. Up to 14 decimal places are permitted, whether specified as an integer or through a Metric. |

## Returns

| Type | Dimensions |
| --- | --- |
| Number | Dimensions of argument *Number* |

`BLANK` if *Number of Digits* is negative or over 14.

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `ROUND(2.19, 1)` | 2.2 | The nearest number from 2.19 with 1 digit is 2.2. |
| `ROUND(2.11, 1)` | 2.1 | The nearest number from 2.11 with 1 digit is 2.1. |
| `ROUND(2.99, 1)` | 3.0 | The nearest number from 2.99 with 1 digit is 3.0. |
| `ROUND(2.99, 2)` | 2.99 | The nearest number from 2.99 with 2 digits is 2.99. |
| `ROUND(2.99)` | 3 | The nearest number from 2.99 with no digits is 3. |
| `ROUND(2.365, 1)` | 2.4 | The nearest number from 2.365 with 1 digit is 2.4. |
| `ROUND(1.11, -1)` | `BLANK` | The *Number of Digits*, -1, is invalid. |
| `ROUND(1.1122334455667788,15)` | `BLANK` | The *Number of Digits*, 15, is invalid. |

## See also

Excel: [ROUND](https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c)

Related articles: [ROUNDUP](/v1/docs/roundup-function), [ROUNDDOWN](/v1/docs/rounddown-function)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!