--- title: "Use the FLOOR Function to Round Numbers Down to the Nearest Integer" slug: "floor-function" description: "Learn to use the FLOOR function in Pigment to round numbers down to the nearest integer and streamline your data modeling." tags: ["FLOOR", "formula syntax", "functions ", "Modeling and Formulas", "Pigment Blocks", "Pigment Boards"] updated: 2025-05-30T09:40:44Z published: 2025-08-22T10:57:28Z canonical: "kb.pigment.com/floor-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. # FLOOR function ## ​​​​Description Rounds down a Number to the nearest Integer value. ## Syntax `FLOOR(Number to Round Down)` ## Arguments | Argument | Type | Dimensions | Description | | --- | --- | --- | --- | | *Number to Round Down* (required) | Number | Any Dimensions | Decimal number to round down. | ## Returns | Type | Dimensions | | --- | --- | | Number | Dimensions of *Number to Round Down* | ## Examples | Formula | Result | Description | | --- | --- | --- | | `FLOOR(2.36)` | 2 | The nearest integer down of 2.36 is 2. | | `FLOOR(-2.36)` | -3 | The nearest integer down of -2.36 is -3. | ## See also Excel: [FLOOR.MATH](https://support.microsoft.com/en-us/office/floor-math-function-c302b599-fbdb-4177-ba19-2c2b1249a2f5) Related articles: [CEILING](/v1/docs/ceiling-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!