Public Function Percent( _
ByVal vX As Variant _
, ByVal vY As Variant _
) As Variant Percent(50, 16) = 8
Percent(25, 16) = 4
Percent(20, 25) = 5See also: PercentVerify Subroutine
PercentChange Function
PercentOfTotal FunctionvX: Percentage of vY that is returned. This number usually represents a part of the whole and it is usually between 0 and 100. 1% is represented by 1 and 100% is represented by 100; NOT 1% represented by .01 NOR 100% represented by 1. Function returns Null if vX is Null or cannot be fixed up to a number. vY: The quantity of which vX percent is returned. This number usually represents the whole. Function returns Null if vX is Null or cannot be fixed up to a number.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.