Function Math Probability Class

LogNormalPDF

Lognormal Probability Density Function

Signature (Visual Basic / VBA)

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

Parameters

Parameter Description
vX Function returns Null if vX cannot be fixed up to a Double precision floating point number.
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.