Posted in MS Excel

How To Make A Perfect Dotted Die in Excel

   Published Date: August 2, 2019  77 Comments on How To Make A Perfect Dotted Die in Excel
Die in Excel

This tutorial covers how to create a die roller in Excel that graphically displays a pair of dice on your Worksheet. The dice can be re-rolled repeatedly by recalculating the worksheet.

The dice will display a random number generated by the RANDBETWEEN function. The dots on the die faces are created using the Wingdings font, and a combination of the AND, IF, and OR functions control when dots appear in each cell. Depending on the random numbers generated by the RANDBETWEEN functions, dots will appear in the appropriate cells in the worksheet.

Building The Die In Excel

The steps below cover the formatting techniques used to graphically display the dice on an Excel worksheet; they include changing cell size and cell alignment, as well as font type and size:

  1. Select cells D1 to J3.
  2. Select the Format button in the Home tab.
  3. Set the Row Height to 24.75 and the Column Width to 5.
  4. Set the Horizontal Cell Alignment to centre and the Vertical Cell
    Alignment to the middle.
  5. Set the Font Type to Wingdings and the Font Size to 36.
  6. Select cells D1 to F3.
  7. Set the Cell Background Colour to blue.
  8. Select cells H1 to J3.
  9. Set the Cell Background Colour to red.

Add The RANDBETWEEN Function For The Die In Excel

The RANDBETWEEN function is used to generate the random numbers shown on
the dice. Follow these steps to implement the random number generator:
For the First Die

  1. Click on cell E5.
  2. Click on the Formulas tab of the ribbon menu.
  3. Choose Math & Trig from the ribbon.
  4. Click on RANDBETWEEN in the list to bring up the Formula Builder.
  5. Click on the bottom line.
  6. Type the number 1 on this line.
  7. Click on the top line.
  8. Type the number 6 on this line.
  9. Click Done.
  10. A random number between 1 and 6 should appear in cell E5.
    For the Second Die
  11. Click on cell I5.
  12. 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, the function places a lowercase L in cells D1 and F3. If not, it leaves the cells blank.


To get the same result for the second die, type the following function
into cells H1and J3 :
=IF(AND(I5>=2, I5<=6),”l”,” “)
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 a dot in cells D2 and F2. If not, it leaves the cell blank. To get the same result for the second die, type the following function H2 and J2:
=IF(I5=6,”l”, ” “)

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 a dot in cells D3 and F1. If not, it leaves the cells blank. To get the same result for the second die, type the following function into cells H3 and J1:
=IF(AND(I5>=4, I5<=6),”l”, ” “)

Rolling The Dice

To roll the dice all you do is press F9 or Fn F9 at the same time.

Go to https://www.computergaga.com/blog/simulate-a-dice-throw-in-excel/ for more information.

To make a snake and ladders game, click on the 2 links below! Snake and Ladder

Author: Trushil Shah

My name is Trushil Shah and I am 13 years old. I live in Australia, a multicultural country. I have a little sister. Here are many things I like to do, to see, and to experience. I like to play sports, study, do technology experiencing, go out into the world, read, write, see the lunar eclipses by a glimpse, share time with my family, code in scratch and most of all have fun. I like flowers in spring, rain in summer, leaves in autumn, and snow in winter. I want to be a doctor or engineer when I grow up. I like many different types of food. My favourite subject of all is Maths. I am always trying to do my best. Whatever I do I want to do best.

77 thoughts on “How To Make A Perfect Dotted Die in Excel”

  38. I’ve been browsing online more than 3 hours today, yet I never found any interesting
    article like yours. It is pretty worth enough for me.
    Personally, if all site owners and bloggers made good content as you did, the internet will be
    a lot more useful than ever before.

  40. It’s perfect time to make some plans for the
    future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few
    interesting things or suggestions. Perhaps you can write next articles referring to this article.
    I want to read more things about it!

  41. Hi there just wanted to give you a quick heads up.
    The words in your post seem to be running off the screen in Chrome.
    I’m not sure if this is a formatting issue or something to do with web browser compatibility but I figured I’d
    post to let you know. The layout look great though! Hope you get the
    problem fixed soon. Many thanks

  42. You made some good points there. I looked on the net to learn more about the issue and found most people
    will go along with your views on this web site.

  44. It’s perfect time to make some plans for the longer term and it’s time to be
    happy. I’ve read this put up and if I could I desire to counsel you
    few interesting things or suggestions. Perhaps you could write subsequent articles regarding this article.
    I want to read more issues approximately it!

  45. Wow! This blog looks just like my old one! It’s on a
    completely different subject but it has pretty much the same page layout and design. Excellent choice of colors!

  47. I simply couldn’t leave your website prior to suggesting that I really loved the usual information an individual
    supply for your visitors? Is gonna be again continuously in order to check out
    new posts

  49. It’s perfect time to make some plans for the future and it’s time to be
    happy. I have read this post and if I could I want to suggest you some
    interesting things or advice. Perhaps you could write
    next articles referring to this article. I want to read even more things about it!

  51. Thank you for your blog post. Jones and I are saving for just a new ebook on this theme and your article has made us to save our money. Your thoughts really answered all our queries. In fact, more than what we had recognized previous to the time we stumbled on your superb blog. I no longer have doubts as well as a troubled mind because you have truly attended to the needs right here. Thanks

  56. Pingback: ed pills over the counter

  63. I’ve been browsing online more than 4 hours today, yet
    I never found any interesting article like yours.
    It’s pretty worth enough for me. In my view, if all webmasters and bloggers made good
    content as you did, the web will be a lot more useful than ever before.

  64. Pingback: casino s on line
  65. Pingback: sildenafil for women

  66. It is the best time to make some plans for the future and
    it is time to be happy. I’ve read this post and if I could I desire to suggest you some interesting things or suggestions.
    Perhaps you could write next articles referring to this article.
    I want to read even more things about it!

  67. It is the best time to make a few plans for the future and it is time to
    be happy. I have learn this publish and if I may just I want to counsel
    you some interesting issues or advice. Perhaps you can write subsequent articles
    referring to this article. I wish to read more issues approximately it!

  69. Its such as you read my mind! You appear to understand so
    much approximately this, like you wrote the guide in it or something.

    I think that you simply could do with some percent to pressure the message
    house a bit, but instead of that, that is excellent blog.

    A great read. I will definitely be back.

  70. Pingback: erythromycin oth

  71. Youu mad slme decennt pointts there. I checcked onn thhe intertnet tto lezrn mor about the
    iasue annd found mosst individuals wkll ggo
    along with yolur views onn tyis website.

  72. Pingback: keflex sjs

  74. I will immediately grasp your rss as I can’t find your
    e-mail subscription hyperlink or newsletter service. Do you have
    any? Please permit me recognise so that I could subscribe.
    Thanks.

  77. I will immediately grasp your rss as I can not in finding your e-mail subscription hyperlink or e-newsletter service. Do you’ve any? Kindly let me realize so that I may subscribe. Thanks.

Comments are closed.