Functions

Generate a random number :

=RAND()

Generate a random integer:

=RANDBETWEEN(bottom,top)

e.g. to roll a fair die:

=RANDBETWEEN(1,6)

Demo