Public Function PercentOfTotal( _
ByVal vX As Variant _
, ByVal vY As Variant _
) As Variant PercentOfTotal(5, 10) = 50
PercentOfTotal(2, 20) = 10
PercentOfTotal(3, 24) = 12.5See also: PercentOfTotalVerify Subroutine
Percent Function
PercentChange FunctionvX: Number representing part of the whole. This number is usually smaller than vY. Function returns Null if vX is Null or cannot be fixed up to a number. vY: Number representing the whole. This number is usually larger than vX. Function returns Null if vX is Null or cannot be fixed up to a number.
Function returns Null if vX is 0 (zero).
v1.5 BugFix: Fixed this function to return Null if vY is 0 (zero), not if vX is 0 (zero) as it did in previous versions of the program.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.