Excel Rolling Dice Tutorial

Overview of Dice Rolling Tutorial

Excel 2007 Dice Roller Tutorial

© Ted French

Overview of Dice Rolling Tutorial

• This tutorial takes you through all the steps necessary to create a dice roller program in Excel. The end result will be a pair of dice on a worksheet.
  
  
• The dice will display graphically a random number generated by the RANDBETWEEN function. The dice can be "rolled" repeatedly by recalculating the worksheet.
  
  
• The dots on the die faces are created using the Wingdings font (see step 1 of this tutorial). The letter "l" ( lowercase L ) is a dot in the Wingdings font.
  
  
• Depending on the random numbers generated by the RANDBETWEEN functions, dots will appear in the appropriate cells of the dice in the worksheet.
  
  
• A combination of AND , IF , and OR functions control when dots appear in each cell of the dice.

The steps in this tutorial are:

1. Building the Dice


2. Adding the RANDBETWEEN Function


3. The Functions behind the Dots (#1)


4. The Functions behind the Dots (#2)


5. The Functions behind the Dots (#3)


6. The Functions behind the Dots (#4)


7. Rolling the Dice


8. Hiding the RANDBETWEEN Function

• 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