D
ddawg09
I know how to get one random number by just using "RAND(x,y)" but how do
I get 100 random numbers?
I get 100 random numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
davesexcel
http://www.uis.edu/ctl/training/detailedtips/excelgeneratingnumbers.htm
A little insight on random()
A little insight on random()
D
ddawg09
What if you only want random numbers within a given range. I need 10
numbers between 5.5 and 10.5 but I did the Randombetween function an
dragged it down but all it did was pretty much copy
numbers between 5.5 and 10.5 but I did the Randombetween function an
dragged it down but all it did was pretty much copy
D
David McRitchie
That is covered very well in the Excel help look up RAND
and I can't improve on that part. I could point you to a macro I use.
and I can't improve on that part. I could point you to a macro I use.
D
daddylonglegs
ddawg09 said:What if you only want random numbers within a given range. I need 100
numbers between 5.5 and 10.5 but I did the Randombetween function and
dragged it down but all it did was pretty much copy.
Don't know if you've got the right formula (RANDBETWEEN will only give
you integers) but if you dragged formula down and the result in each
cell is the same then calculation may be set to manual. Hit F9 to
re-calculate or set calculation to Automatic using Tools menu and
Options....
B
Biff
Hi!
If you're using the RANDBETWEEN function it only returns integers (whole
numbers).
You could try this:
=RANDBETWEEN(55,105)/10
Biff
If you're using the RANDBETWEEN function it only returns integers (whole
numbers).
You could try this:
=RANDBETWEEN(55,105)/10
Biff