How to control =RAND()

[JoshuaHefflinger]

I was wondering if it were possible to make the RAND() function to randomly give me a number between 1-6, and always an integer?

Or really, any form of combination like that. Thanks.

 

[VoG]

Try

=RANDBETWEEN(1,6)

This requires (in Excel 2003 and before) the Analysis ToolPak to be installed from Tools > Add-Ins.

 

[shg]

=INT(6*RAND())+1

or

=RANDBETWEEN(1, 6)

 

[JoshuaHefflinger]

=INT(6*RAND())+1

This seems to do the trick! Thank you very much.

I'll keep the other formula in mind though, for if I do ever upgrade past 2002.