The only problem with your formula is that you'll *never* get a "9".

This bug (wrong information) has been around for years in the Help files,
where I'll bet, is where you got this formula from.

Try this instead:

=INT(RAND()*(9)+1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"BaldySlaphead"
wrote in message
news:BaldySlaphead.1s45mw_1121267162.1931@excelfor um-nospam.com...

Thank you, sir, that works fine! :)


--
BaldySlaphead
------------------------------------------------------------------------
BaldySlaphead's Profile:
http://www.excelforum.com/member.php...fo&userid=1260
View this thread: http://www.excelforum.com/showthread...hreadid=386779