# FLOOR

The *FLOOR* function rounds a number toward zero to the nearest specified multiple of significance. It accepts numeric values or node references as arguments and returns the rounded result based on the given multiple.

#### Syntax

```javascript
FLOOR(value, significance)
```

#### Arguments

* `value`: Number or node reference to round.
* *`significance`* (Optional): The multiple to which the number should be rounded. If not specified, the number is rounded down to the nearest integer toward zero.

#### Return value

Returns the number rounded toward zero to the specified multiple.

#### Example

```javascript
FLOOR(Planned Units, 3)
```

In this example, the FLOOR function is used to create the *Rounded Off Units* measure, which returns the values in the *Planned Units* measure rounded down to the nearest multiple of 3.

<figure><img src="/files/UZcOJj4OfopJT49fkRzV" alt=""><figcaption></figcaption></figure>

#### Excel Equivalent

[FLOOR](https://support.microsoft.com/en-us/office/floor-function-14bb497c-24f2-4e04-b327-b0b4de5a8886)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/formula-syntax/math-functions/floor.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.