Excel Dice Roller Tutorial

Overview of Dice Roller Tutorial

Excel 2007 Dice Roller Tutorial

© Ted French

Overview of Dice Roller 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

Index: Excel Dice Roller Tutorial

1. Overview of Dice Roller Tutorial
2. Building the Dice
3. Adding the RANDBETWEEN Function
4. The Functions behind the Dots (#1)
5. The Functions behind the Dots (#2)
6. The Functions behind the Dots (#3)
7. The Functions behind the Dots (#4)
8. Rolling the Dice
9. Hiding the RANDBETWEEN Function