ExcelBanter - Random number generator

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Random number generator (https://www.excelbanter.com/excel-worksheet-functions/114130-random-number-generator.html)

deelee

Random number generator

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

N Harkawat

Random number generator

=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

Teethless mama

Random number generator

=RANDBETWEEN(1,12)
Require Analysis ToolPak Add-Ins

"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

daddylonglegs

Random number generator

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

All times are GMT +1. The time now is 08:38 AM.