---
title: "Use the ROUNDDOWN Function to Round Numbers Down Precisely"
slug: "rounddown-function"
description: "Learn to use the ROUNDDOWN function to round numbers down to a specific number of digits with precision in Pigment models."
tags: ["formula syntax", "functions ", "Modeling and Formulas", "Pigment Blocks", "Pigment Boards", "ROUNDDOWN"]
updated: 2025-06-09T11:04:23Z
published: 2025-08-22T10:56:55Z
canonical: "kb.pigment.com/rounddown-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.

# ROUNDDOWN function

## ​​​Description

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

## Syntax

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

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Number* (required) | Number | Any Dimensions | Number to round down. |
| *Number of Digits* (optional) | Integer or Metric | No Dimension or Dimensions of argument *Number* | Number of decimal places to round down to. By default, the argument *Number* is rounded down 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 |
| --- | --- | --- |
| `ROUNDDOWN(2.19, 1)` | 2.1 | 2.19 rounded down with 1 digit is 2.1. |
| `ROUNDDOWN(2.11, 1)` | 2.1 | 2.11 rounded down with 1 digit is 2.1. |
| `ROUNDDOWN(2.9)` | 2 | 2.9 rounded down to the nearest integer is 2. |
| `ROUNDDOWN(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: [ROUNDDOWN](https://support.microsoft.com/en-us/office/rounddown-function-2ec94c73-241f-4b01-8c6f-17e6d7968f53)

Related articles: [ROUNDUP](/v1/docs/roundup-function), [ROUND](/v1/docs/round-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!