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
| Row | A |
|---|---|
| 6 | Input |
| 7 | 0.5 |
| 8 | 1 |
| 9 | 2 |
Record 1
=LOGNORMDIST(A7,.2,.5)Illustrative output0.03702580472
See the inputs and instructions for all 3 examplesCompatibility 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 |