Function Math Probability Class

LogNormalRandom

Random Number with Lognormal Distribution

Signature (Visual Basic / VBA)

Public Function LogNormalRandom( _
      Optional ByVal vMean As Variant = 0# _
    , Optional ByVal vStdDev As Variant = 1# _
    ) As Variant

Parameters

Parameter Description
vMean Mean of the distribution. Function returns Null if vMean cannot be fixed up to a Double precision floating point number. Argument defaults to a value of zero (0) if it is missing.
vStdDev Standard deviation of the distribution. Function returns Null if vStdDev is less than or equal to zero (<=0). Argument defaults to a value of one (1) if it is missing.