Calculation

Excel formula

Generate Random Integers | # gomaths.net/4247         User submitted, thanks to

Use the RANDBETWEEN function to generate random integers.

=RANDBETWEEN(bottom,top)

where bottom is the smallest integer RANDBETWEEN will return and
top is the largest integer RANDBETWEEN will return.

For example, to simulate a six-sided dice.

=RANDBETWEEN(1,6)