FLOOR() Rounds down to the next integer ------------------------------------------------------------------------------ Syntax FLOOR(<nValue>) --> nSmallerInteger Argument <nValue> Designates the number for which the next-smaller integer is determined. Returns FLOOR() returns the next-smaller integer of the one passed as a parameter. Description FLOOR() always returns the next-smaller integer of the one passed as a parameter. This applies to positive and negative numbers. Example Show the next-smaller integer for positive and negative numbers: ? FLOOR(1.9) // Result: 1 ? FLOOR(1.1) // Result: 1 ? FLOOR(0.9) // Result: 0 ? FLOOR(-0.1) // Result: -1 ? FLOOR(-0.9) // Result: -1 ? FLOOR(-1.1) // Result: -2
See Also: CEILING()