Public Function Floor( _
ByVal vNumber As Variant _
, Optional ByVal vPrecision As Variant _
) As Variant Floor(2.4) = 2
Floor(2) = 2
Floor(.6) = 0
Floor(0) = 0
Floor(-.6) = -1
Floor(-2) = -2
Floor(-2.4) = -3
Floor(-1.4, .5) = -1.5
Floor(-1.7, .5) = -2See also: FloorVerify Subroutine
Ceiling Function
RoundToPrecision Function
PreviousNumber Function
IntReal FunctionNote: The IntReal function is a more specific version of Floor. vNumber: The number that is to be rounded-down. Function returns Null if vNumber is Null or cannot be fixed up to a number.
vPrecision: The precision used when rounding vNumber. vPrecision defaults to 1 (one) if it is missing or Null or cannot be fixed up to a number.
Note: With a precision of 1 (one), function returns the largest integer less than or equal to vNumber, which is equivalent to the IntReal function.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.