Excel Rolling Dice Tutorial

Adding the RANDBETWEEN Function

The RANDBETWEEN Function

© Ted French

Adding the RANDBETWEEN Function

The RANDBETWEEN function is used to generate the random numbers shown on the two dice.

For the first die

1. Click on cell E5.
   
   
2. Click on the Formulas tab of the ribbon menu.
   
   
3. Choose Math & Trig from the ribbon to open the function drop down list.
   
   
4. Click on RANDBETWEEN in the list to bring up the function's dialog box.
   
   
5. Click on the "Bottom" line in the dialog box.
   
   
6. Type the number 1 (one) on this line.
   
   
7. Click on the "Top" line in the dialog box.
   
   
8. Type the number 6 (six) on this line.
   
   
9. Click OK.
   
   
10. A random number between 1 and 6 should appear in cell E5.

For the second die

1. Click on cell I5.
   
   
2. Repeat steps 2 to 9 above.
   
   
3. A random number between 1 and 6 should appear in cell I5.

Return to Overview Page

• Overview of Dice Rolling Tutorial
• Building the Dice
• Adding the RANDBETWEEN Function
• The Functions behind the Dots (#1)
• The Functions behind the Dots (#2)
• The Functions behind the Dots (#3)
• The Functions behind the Dots (#4)
• Rolling the Dice
• Hiding the RANDBETWEEN Function