FLOOR

Description

The FLOOR function rounds a number towards zero to the nearest whole number.

Usage

FLOOR(value)
Argument Type Required Description
value Numeric Yes The value to round

Result

The nearest whole number when down (towards zero) from the given value.

Example

When thinking about people's ages, we generally think in whole numbers, and round down. For example, someone who is six months away from their eighteenth birthday is 17.5 years old, but we would normally say they are 17 years old.

You can use the FLOOR function together with the YEARFRAC and TODAY functions to calculate someone's age in whole numbers:

FLOOR(YEARFRAC(DOB, TODAY()))
Next item
GREATER (>)