---
title: "Use the CEILING Function to Round Numbers Up to the Nearest Integer"
slug: "ceiling-function"
description: "Learn to use the CEILING function in Pigment to round numbers up to the nearest integer and streamline your data modeling."
tags: ["CEILING", "formula syntax", "functions ", "Modeling and Formulas", "Pigment Blocks", "Pigment Boards"]
updated: 2025-05-30T09:41:04Z
published: 2025-08-22T10:57:28Z
---

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

# CEILING function

## ​​​Description

Rounds up a Number to the nearest Integer value.

## Syntax

`CEILING(Number to Round Up)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Number to Round Up* (required) | Number | Any Dimensions | Decimal number to round up. |

## Returns

| Type | Dimensions |
| --- | --- |
| Number | Dimensions of *Number to Round Up* |

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `CEILING(2.36)` | 3 | The nearest integer up of 2.36 is 3. |
| `CEILING(-2.36)` | -2 | The nearest integer up of -2.36 is -2. |

## See also

Excel: [CEILING.MATH](https://support.microsoft.com/en-us/office/ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8)

Related articles: [FLOOR](/v1/docs/floor-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!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>