EXP(z) where z is a normal random number. In 2003 with the recent patch
for the RAND() function, you could use

=EXP(NORMINV(RAND(),mean,stdev)

but this will frequently give unsatisfactory results in earlier versions.

Jerry

ExcelMonkey < wrote:

Does anyone know how to generate random numbers with lognormal
distributions? I am assuming that I can use the LogInv and LogNormDist
function. But as with the normal distributions, I would assume that
this would be slow. Does anyone know of a VBA sub that generates
random numbers lognormally.