1. Computing

Excel Rolling Dice Tutorial

By

1 of 9

Overview Excel Dice Roller Tutorial
Excel Dice Roller Tutorial

Excel Dice Roller Tutorial

© Ted French

Tutorial Overview

  • This tutorial covers how to create a dice roller program in Excel

  • The tutorial uses formatting techniques to graphically display one face of a pair of dice as seen in the image above

  • The dice will display a random number generated by the RANDBETWEEN function

  • The dots on the die faces are created using the Wingdings font

  • A combination of AND , IF , and OR functions control when dots appear in each cell of the dice

  • Depending on the random numbers generated by the RANDBETWEEN functions, dots will appear in the appropriate cells of the dice in the worksheet

  • The dice can be "rolled" repeatedly by recalculating the worksheet

The steps in this tutorial are:

  1. Building the Dice

  2. Adding the RANDBETWEEN Function

  3. The Functions behind the Dots: Nesting the AND and IF Functions

  4. The Functions behind the Dots: Using the IF Function Alone

  5. The Functions behind the Dots : Nesting the AND and IF Functions

  6. The Functions behind the Dots: Nesting the OR and IF Functions

  7. Rolling the Dice

  8. Hiding the RANDBETWEEN Functions

©2014 About.com. All rights reserved.