# LOGNORM.DIST

### Definition

Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.

Use this function to analyze data that has been logarithmically transformed.

### Sample Usage

### Syntax

LOGNORM.DIST(x,mean,standard_dev,cumulative)

The LOGNORM.DIST function syntax has the following arguments:

X Required. The value at which to evaluate the function.

Mean Required. The mean of ln(x).

Standard_dev Required. The standard deviation of ln(x).

Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

### Remarks

If any argument is nonnumeric, LOGNORM.DIST returns the #VALUE! error value.

If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value.

The equation for the lognormal cumulative distribution function is:

LOGNORM.DIST(

*x,µ,o*) = NORM.S.DIST(*1n(x)-µ / o*)

### In order to use the LOGNORM.DIST formula, start with your edited Excellentable

### Then type in the LOGNORM.DIST formula in the area you would like to display the outcome:

### By adding the values you would like to calculate the LOGNORM.DIST formula for, Excellentable will generate the outcome: