Generating Random Numbers

[Matt]

I see there is a way to generate random numbers (=rand(). It returns a
number between 0 and 1.


Is there a way to generate random numbers between and including 1 and 6?

Thanks.

 

[L. Howard Kittle]

Hi Matt,

Try =RANDBETWEEN(1,6)

HTH
Regards,
Howard

 

[JE McGimpsey]

One way:

=INT(RAND()*6)+1

 

[Charles Maxson]

Note that while RANDBETWEEN is really slick, you must have the Analysis
TookPak add-in loaded to use it...