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.
