Each die displays a random number generated by theRANDBETWEENfunction.
Depending on the random numbers the RANDBETWEEN function generates, dots will appear in the appropriate cells in theworksheet.
The dice can be re-rolled repeatedly by recalculating the worksheet.
These instructions apply to Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010.
These include changing the cell size and cell alignment, as well as font bang out and size.
Open a blank worksheet in Excel and selectcellsD1toJ3.
SelectFormatin the Cells group of theHometab.
SelectRow Heightand enter24.75.SelectColumn Widthand enter5.
SelectFormat Cellsat the bottom of theFormatdrop-down menu and go theAlignmenttab.
Set theHorizontal Cell AlignmentandtheVertical Cell Alignmenttocenterand selectOK.
SelectWingdingsin theFontlist and set theFont Sizeto36.
Right-poke the selected cells and chooseFormat Cells.
Go to theFilltab and chooseBluefor the Background Color.
SelectOKto apply the color and wrap up the dialog box.
Right-hit the selected cells and chooseFormat Cells.
Go to theFilltab and chooseRedfor the Background Color.
SelectOKto apply the color and terminate the dialog box.
SelectcellE5under the Blue die.
SelectMath & Trigfrom the Function Library group.
SelectRANDBETWEENin the list to bring up the function dialog box.
Enter1in theBottomfield and6in theTopfield.
A random number between 1 and 6 will appear in cellE5.
Enter the same formula into cellI5.
A random number between 1 and 6 will appear in cellI5.
Some of the cells also include theANDorORfunction.
If not, it leaves the cells blank.
If not, it leaves the cell blank.
If not, it leaves the cells blank.
If not, it leaves the cell blank.
Recalculating causes theRANDBETWEENfunctions incellsE5andI5to generate another random number between 1 and 6.
