Random integers

[nick]

Is it possible to generate random integers between
certain numbers?

By using the RAND function and multiplying the number by
10 (or 100) it is possible to generate random integers
between 0-9 or 0-99, but is it possible to generate
random integers between, say, 1-8? or 1-50?

Any help would be much appreciated!

 

[Frank Kabel]

Hi
one way:
use RANDBETWEEN from the Analysis Toolpak add-in. e.g.
=RANDBETWEEN(1,87)

another way:
=INT((upperbound - lowerbound + 1) * RAND() + lowerbound)

 

[Max]

Try RANDBETWEEN()

For example: =RANDBETWEEN(1,50)
would generate random integers between 1 - 50

RANDBETWEEN requires the Analysis Toolpak* be
installed and activated

Check the "Analysis Toolpak" box via Tools > Add-Ins

Chip Pearson's page has details on the ATP at:
http://www.cpearson.com/excel/ATP.htm

 

[Andrew]

For between and including 1 and 8, I think =INT(RAND()*8)+1 will do th
trick. If you don't want to include 1 or 8, try =RANDBETWEEN(2,7). Th
RANDBETWEEN function requires the Analysis Toolpak

 

[Guest]

Thanks guys, I really appreciate it!

 

[Andrew]

*Thanks guys, I really appreciate it! *

Always glad to help :

 

[Max]

Pleasure' Nick !
Thanks for the feedback