| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Random Number generator | Excel Worksheet Functions | |||
| VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
| Random Number Generator | Excel Worksheet Functions | |||
| Random number generator | Excel Worksheet Functions | |||
Linear Mode
