Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How to create Roll the Dice in Excel

This example teaches you how to simulate the roll of two dice in Excel.

Note: the instructions below do not teach you how to format the worksheet.

We assume that you know how to change font sizes, font styles, insert rows and columns, add borders, change background colors, etc.

1. At the moment, each cell contains the letter l (as in lion). With a Wingdings font style, these l’s look like dots.

Worked Example:   How to randomly assign data to groups in Excel

2. Enter the RANDBETWEEN function in cell C2.

3. Enter the formula shown below into the yellow cells. If we roll 2, 3, 4, 5 or 6, these cells should contain a dot.

Worked Example:   How to generate random date between two dates in Excel

4. Enter the formula shown below into the red cells. If we roll 4, 5 or 6, these cells should contain a dot.

5. Enter the formula shown below into the blue cells. If we roll 6, these cells should contain a dot.

6. Enter the formula shown below into the gray cell. If we roll 1, 3 or 5, this cell should contain a dot.

Worked Example:   RANDBETWEEN function: Description, Usage, Syntax, Examples and Explanation

7. Copy the range C2:E5 and paste it to the range G2:I5.

8. Change the font color of cell C2 and cell G2 to green (so the numbers are not visible).

9. Click the command button on the sheet (or press F9).

Result.

Leave a Reply

Your email address will not be published. Required fields are marked *