Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how to generate a rondom number btween two ranges

  Asked By: Ruben    Date: Oct 04    Category: MS Office    Views: 1073
  

how to generate a rondom number btween two ranges?

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Phyllis Foster     Answered On: Oct 04

A range is an area on a spreadsheet. Do you mean between two numeric values?

 
Answer #2    Answered By: Levi Wilson     Answered On: Oct 04

Have a look at the RANDBETWEEN function...............

 
Answer #3    Answered By: Brock Smith     Answered On: Oct 04

=rand()........................................

 
Answer #4    Answered By: Sheri Porter     Answered On: Oct 04

Keep in mind that the VBA Rnd() function has a cycle of just 16.7
million random numbers. (At least, that was the case in Excel
2002).

If you need more than 16.7 million random numbers for an application,
as I did, you will need to create the numbers with another
algorithm. I settled on the Mersenne Twister algorithm, which,
thankfully, is pretty efficient!

See: www.math.sci.hiroshima-u.ac.jp/~m-mat/MT/emt.html

 
Didn't find what you were looking for? Find more on how to generate a rondom number btween two ranges Or get search suggestion and latest updates.




Tagged: