Hi,

I'm trying to generate a lognormal distribution in Excel. While it is
possible to produce a lognormal distribution by first generating a
normal distribution using the Data Analysis function, the normal
distribution may at times contain negative numbers which cannot be
converted into a log equivalent.

Would appreciate if someone knows an easy way to generate a lognormal
distribution.

Thank you.