ExcelFlux

LOGNORMDIST function

the cumulative lognormal distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find the legacy lognormal lower-tail probability for positive readings.

A worked example from the workbook

RowA
6Input
70.5
81
92
Record 1
=LOGNORMDIST(A7,.2,.5)

Illustrative output0.03702580472

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Find the legacy lognormal lower-tail probability for positive readings.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.5
8 1
9 2
Trial Expression Sample output
Record 1 =LOGNORMDIST(A7,.2,.5) 0.03702580472
Record 2 =LOGNORMDIST(A8,.2,.5) 0.3445782584
Record 3 =LOGNORMDIST(A9,.2,.5) 0.838005657
Microsoft Excel reference