Notification

AppSheet will be conducting service maintenance starting Sunday, May 19th, 2024 at 12:00 PM (7:00 PM UTC) and completing no later than 4:00 PM PDT (11:00 PM UTC). Learn more

FLOOR()

Round down to nearest integer

Returns the nearest integer rounded down.

Sample usage

FLOOR(3.14) returns 3

FLOOR(-3.14) returns -4

FLOOR(5) returns 5

Syntax

FLOOR(x)

  • x - Any numeric value.

See also

ABS()

CEILING()

ROUND()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Main menu
15973136731132929802
true
Search Help Center
true
true
true
false
false