Document Solutions for Excel, Java Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
  - BETADIST
  - BETAINV
  - BINOMDIST
  - CHIDIST
  - CHIINV
  - CHITEST
  - CONFIDENCE
  - COVAR
  - CRITBINOM
  - EXPONDIST
  - FDIST
  - FINV
  - FLOOR
  - FTEST
  - GAMMADIST
  - GAMMAINV
  - HYPGEOMDIST
  - LOGINV
  - LOGNORMDIST
  - MODE
  - NEGBINOMDIST
  - NORM.INV
  - NORMDIST
  - NORMSDIST
  - NORMSINV
  - PERCENTILE
  - PERCENTRANK
  - POISSON
  - QUARTILE
  - RANK
  - STDEV
  - STDEVP
  - TDIST
  - TINV
  - TTEST
  - VAR
  - VARP
  - WEIBULL
  - ZTEST
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Use JDK 8 Date Time API
Document Solutions Data Viewer
API Reference
Release Notes

LOGNORMDIST

This function returns the cumulative natural log-normal distribution of x, where LN(x) is normally distributed with the specified mean and standard deviation. Analyze data that has been logarithmically transformed with this function.

Syntax

LOGNORMDIST(x, mean, stdev)

Arguments

This function has these arguments:

Argument	Description
x	[Required] Value at which to evaluate the function
mean	[Required] Value of mean of the natural logarithm of x, LN(x)
stdev	[Required] Value representing the standard deviation of LN(x)

Remarks

If p = LOGNORMDIST( x, ...) then LOGINV( p, ...) = x.

Examples

LOGNORMDIST(0.92,B8,G22)