unfortunately no. The rand() function only delivers a random number
that is uniformly distributed between 0 and 1. You can use the
norminv(rand()) function combination to create a normally distributed
random number with a mean and stdev of your choosing.


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=391865