Theorectically RAND() can generate a zero, in which case

=ROUNDUP(RAND()*12,0)

will generate zero

better to use

=INT(RAND()*12)+1


"N Harkawat" wrote:


=ROUNDUP(RAND()*12,0)

"deelee" wrote:


I recently got a new installation of excel but it is in Spanish and am
struggling a bit with the help instructions.

I want to make a random number generator a bit like bingo with the
numbers 1 to 12.
Gracias!


--
deelee
------------------------------------------------------------------------
deelee's Profile: http://www.officehelp.in/member.php?userid=4683
View this thread: http://www.officehelp.in/showthread.php?t=1228222

Posted from - http://www.officehelp.in