| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper and Lower Bounds and Rnd
I have been using the following formula to generate a random number
between 1 and 42. I have made my UpperBounds = 42 and my LowerBounds = 1. I ran 1,000 iterations and in several instances, the random number generated equaled 43. How is this? Is there an error in my logic? RandomNumber = Int((UpperBounds - LowerBounds) + 1)* Rnd + LowerBounds TS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| How to fix lower and upper bounds for data | Excel Worksheet Functions | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
| Normal Distrubtions with Upper/Lower Bounds | Excel Programming | |||
Threaded Mode
