Excel Random Number generation for Lognormal distribution

[John Veenstra]

Woould like to know how to have Excel generate random
numbers conforming to lognormal distribution

 

[GB]

To make that completely clear use

=exp(normsinv(Rand()))

Geoff