=RAND()*(95+5)-5
This will generate a random number between -5 and 95 using formulas in
a cell of the worksheet.
--
goober
------------------------------------------------------------------------
goober's Profile:
http://www.excelforum.com/member.php...o&userid=19838
View this thread:
http://www.excelforum.com/showthread...hreadid=496073