Public Function IsWithinPlusOrMinusOf( _ ByVal vCheck As Variant _ , ByVal vVariance As Variant _ , ByVal vTarget As Variant _ ) As Variant
IsWithinPlusOrMinusOf(53, 10, 55) = True IsWithinPlusOrMinusOf(45, 10, 55) = True IsWithinPlusOrMinusOf(35, 10, 55) = False IsWithinPlusOrMinusOf(75, 10, 55) = FalseSee also:
IsBetween Function RangeComp FunctionvCheck: The value that is checked to see if it is within the range from vTarget plus or minus vVariance. Function returns Null if vCheck is Null or cannot be fixed up to a number.
vTarget: The middle of the range of values against which vCheck is compared. Function returns Null if vTarget is Null or cannot be fixed up to a number.
vVariance: The middle of the range of values against which vVariance is compared. Function returns Null if vVariance is Null or cannot be fixed up to a number.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.