Using a few functions, you can create a dice roller that graphically displays a pair of dice on your worksheet.
How to Make Dice in Excel Step by Step 🎲
Each die displays a random number generated by the RANDBETWEEN function. The dots on the die faces use the Wingdings font, and a combination of the AND, IF, and OR functions determine when dots appear in each cell.
Depending on the random numbers generated by the RANDBETWEEN function, dots will appear in the appropriate cells in the worksheet. The dice can be repeatedly re-rolled by recalculating the worksheet.
First, you need to apply a few formatting techniques to display the dice on an Excel worksheet. These include changing the cell size and cell alignment, as well as the font and size.
