LOGNORMDIST

Syntax:

LOGNORMDIST ( x , mean , standard-dev )

Description: Calculates the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard-dev.

Mathematical Formula:

Arguments:

Name

Type

Description

x

number

The value at which to evaluate the function.

mean

number

The mean of ln(x).

standard-dev

number

The standard deviation of ln(x).

Return Type and Value: number – The inverse of the lognormal cumulative distribution function of x.

However, if

  • ≤ 0, #NUM! is returned.

  • standard-dev ≤ 0, #NUM! is returned.

example: