Advertisements
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()
Advertisements