Table of Contents

Roll the Dice

This example teaches you how to simulate the roll of two dice in Excel. If you are in a hurry simply download the Excel file.

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.

Wingdings Font Style

2. Enter the RANDBETWEEN function in cell C2.

RandBetween Function

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.

Yellow Cells

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

Red Cells

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

Blue Cells

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

Gray Cell

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:

Roll the Dice

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog