In this article, I will show you how to simulate the rolling of two dice in Excel.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to create dice in Excel
1. Currently, each cell contains the letter l (as in Lion). With the Wingdings font style, these l’s look like dots.
2. Enter the function RANDBETWEEN in cell C2.
3. Enter the formula shown below in the yellow cells. If we roll 2, 3, 4, 5 or 6, these cells must contain a dot.
4. Enter the formula shown below in the red cells. If we roll 4, 5 or 6, these cells must contain a dot.
5. Enter the formula shown below into the blue cells. If we scroll 6, these cells will contain a dot.
6. Enter the formula shown below in the gray cell. If we scroll 1, 3 or 5, this cell must contain a dot.
7. Copy the range C2:E5 and paste it into the range G2:I5.
8. Change the text color of cell C2 and cell G2 to green.
9. Click the command button on the worksheet (or press F9).
Result:
In addition, you can also view many other excel articles here.
