Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random numbers
is there any way of only generating whole numbers within a
certain range with the rnd function |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random numbers
Ed,
Install the Analysis Toolpack add-in Tools - Add-ins and check off the "Analysis Toolpack". You might need your install discs depending on your installation. Once complete you can use the RANDBETWEEN worksheet function, which does exactly what your asking for. Dan E "ed" wrote in message ... is there any way of only generating whole numbers within a certain range with the rnd function |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random numbers
=Trunc(rand()*100+1)
drag fill down for as many cells as you need numbers. will generate whole numbers (not unique) between 1 and 100 inclusive. -- Regards, Tom Ogilvy "ed" wrote in message ... is there any way of only generating whole numbers within a certain range with the rnd function |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random numbers
-----Original Message----- is there any way of only generating whole numbers within a certain range with the rnd function . Let's say the range is 5 to 20 the formula would be =round(5+(rand()*15),0) copied over the range required. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random numbers
This formula will generate whole numbers between 5 and 20 inclusive, but
both 5 and 20 have half the probability of occurring as the numbers 6 to 19 inclusive. =Trunc(rand()*15+5) will fix this. -- Regards, Tom Ogilvy "Steve Lerner" wrote in message ... -----Original Message----- is there any way of only generating whole numbers within a certain range with the rnd function . Let's say the range is 5 to 20 the formula would be =round(5+(rand()*15),0) copied over the range required. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |