| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
same number appears in a random number generator
My formula for a lottery number selector is =INT(49*RAND()) but the problem
is that sometimes it generates the same numbers two or more times. I know its something to do with the IF function, but can work out how to stop it. Please Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| random number with text | Excel Worksheet Functions | |||
| random number | Excel Discussion (Misc queries) | |||
| Can excel be used to create a random number generator? | Excel Discussion (Misc queries) | |||
| How can I get Positive values only from the random number generat. | Excel Discussion (Misc queries) | |||
Threaded Mode
