FLOOR
Stay organized with collections
Save and categorize content based on your preferences.
Returns the nearest integer less than or equal to the specified value.
Sample usage
FLOOR(Height)
Syntax
FLOOR( X )
Parameters
X - a field or expression containing at least one field.
Note
FLOOR( X ) is always less than or equal to X.
Examples
| Example formula |
Input |
Output |
FLOOR(Height) |
20.34 |
20 |
FLOOR(Height) |
-40.3 |
-41 |
FLOOR(Height) |
50 |
50 |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-07-29 UTC.
[null,null,["Last updated 2026-07-29 UTC."],[],[]]
