This tutorial covers how to create a dice roller program in Excel and uses formatting techniques to graphically display one face of a pair of dice.

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.

### Excel Dice Roller Tutorial Steps

The steps to build an Excel Dice Roller are as follows:

- Building the Dice
- Adding the RANDBETWEEN Function
- The Functions Behind the Dots: Nesting the AND and IF Functions
- The Functions Behind the Dots: Using the IF Function Alone
- The Functions Behind the Dots: Nesting the AND and IF Functions
- The Functions Behind the Dots: Nesting the OR and IF Functions
- Rolling the Dice
- Hiding the RANDBETWEEN Functions

### Building the Dice

The steps below cover the formatting techniques used to graphically display one face of a pair of dice in your worksheet to create the two dice.

The formatting techniques applied include changing cell size, cell alignment, and changing font type and size.

- Drag select cells
**D1**to**J3** - Set the
**row height**of these cells to**25** - Set the
**column width**of these cells to**5** - Set the
**horizontal cell alignment**to**center** - Set the
**vertical cell alignment**to**middle** - Set the
**font type**to**Wingdings** - Set the
**font size**to**30**

### Dice Color

- Drag select cells
**D1**to**F3** - Set the
**cell background colo**r to**blue** - Drag select cells
**H1**to**J3** - Set the
**cell background color**to**red**

### 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**.

### The Functions Behind the Dots (#1)

In cells **D1** and **F3** type the following function:

= IF ( AND ( E5> = 2 , E5 < = 6 )," l " , " ")

This function tests to see if the random number in cell **E5** is between 2 and 6. If so, it places an "l" in cells **D1** and **F3**. If not, it leaves the cells blank ("").

To get the same result for the second die, in cells **H1** and **J3** type the function:

= IF ( AND ( I5 > = 2 , I5 < = 6 )," l " , " ")

**Remember: **The letter "l" ( lowercase L ) is a dot in the Wingdings font.

### The Functions Behind the Dots (#2)

In cells **D2** and **F2** type the following function:

= IF ( E5 = 6 , " l " , " " )

This function tests to see if the random number in cell E5 is equal to 6. If so, it places an "l" in cells D2 and F23. If not, it leaves the cell blank ("").

To get the same result for the second die, in cells **H2** and **J2** type the function:

= IF ( I5 = 6 , " l " , " " )

**Remember: **The letter "l" ( lowercase L ) is a dot in the Wingdings font.

### The Functions Behind the Dots (#3)

In cells **D3** and **F1** type the following function:

= IF ( AND ( E5 > = 4 , E5 < = 6 )," l " , " ")

This function tests to see if the random number in cell E5 is between 4 and 6. If so, it places an "l" in cells D1 and F3. If not, it leaves the cells blank ("").

To get the same result for the second die, in cells **H3** and **J1** type the function:

= IF ( AND ( I5 > = 4 , I5 < = 6 )," l " , " ")

**Remember: **The letter "l" ( lowercase L ) is a dot in the Wingdings font.

### The Functions Behind the Dots (#4)

In cell **E2** type the following function:

= IF ( OR ( E5 = 1 , E5 = 3 , E5 = 5 ) , " l " , " ")

This function tests to see if the random number in cell E2 is equal to 1, 3, or 5. If so, it places an "l" in cell E2. If not, it leaves the cell blank ("").

To get the same result for the second die, in cell **I2** type the function:

= IF ( OR ( I5 = 1 , I5 = 3 , I5 = 5 ) , " l " , " ")

**Remember: **The letter "l" ( lowercase L ) is a dot in the Wingdings font.

### Rolling the Dice

To "roll" the dice, press the **F9** key on the keyboard.

Doing this causes Excel to recalculate all functions and formulas in the worksheet. This will cause the RANDBETWEEN functions in cells E5 and I5 to generate another random number between 1 and 6.

### Hiding the RANDBETWEEN Function

Once the dice are complete and all functions have been tested to ensure they are operating correctly, the RANDBETWEEN functions in cells E5 and I5 can be hidden.

Hiding the functions is an optional step. Doing so adds to the "mystery" of how the dice roller works.

### To Hide the RANDBETWEEN Functions

- Drag select cells
**E5**to**I5**. - Change the
**font color**of these cells to match the background color. In this case, change it to**white**.