Tweet
Adding the RANDBETWEEN Function
The RANDBETWEEN function is used to generate the random numbers shown on the two dice.
For the first die
Click on cell E5.
Click on the Formulas tab of the ribbon menu.
Choose Math & Trig from the ribbon to open the function drop down list.
Click on RANDBETWEEN in the list to bring up the function's dialog box.
Click on the "Bottom" line in the dialog box.
Type the number 1 (one) on this line.
Click on the "Top" line in the dialog box.
Type the number 6 (six) on this line.
Click OK.
A random number between 1 and 6 should appear in cell E5.
For the second die
Click on cell I5.
Repeat steps 2 to 9 above.
A random number between 1 and 6 should appear in cell I5.
The RANDBETWEEN function is used to generate the random numbers shown on the two dice.
For the first die
Click on cell E5.
Click on the Formulas tab of the ribbon menu.
Choose Math & Trig from the ribbon to open the function drop down list.
Click on RANDBETWEEN in the list to bring up the function's dialog box.
Click on the "Bottom" line in the dialog box.
Type the number 1 (one) on this line.
Click on the "Top" line in the dialog box.
Type the number 6 (six) on this line.
Click OK.
A random number between 1 and 6 should appear in cell E5.
For the second die
Click on cell I5.
Repeat steps 2 to 9 above.
A random number between 1 and 6 should appear in cell I5.