Public Function PreviousNumber( _ ByVal vX As Variant _ , Optional ByVal vPrecision As Variant _ , Optional ByVal vOffset As Variant _ ) As Variant
PreviousNumber(0, 2, 1) = -1 PreviousNumber(1, 2, 1) = -1 PreviousNumber(2, 2, 1) = 1 PreviousNumber(22.4, 2, 1) = 21 PreviousNumber(-1.7) = -3 PreviousNumber(-6.5) = -7 PreviousNumber(-7.8) = -8See also:
PreviousNumberSample Subroutine NextNumber Function PreviousEven Function PreviousOdd FunctionvX: Number which is rounded down to the next number. Function returns Null if vX 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. With a precision of 1 (one), function returns the smallest integer greater than vNumber.
vOffset: The starting number in the sequence to which vX is rounded up. vOffset defaults to 0 (zero) if it is missing or Null or cannot be fixed up to a number. With a precision of 2 and an offset of 0, function returns the previous even number. With a precision of 2 and an offset of 1, function returns the previous odd number.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.