A die is a cube with the numbers 1 through 6 on its sides. Dice is the plural of die. Rolling a die is approximately the same as picking a random integer between 1 and 6 inclusive. It is approximate only because dice are not perfect.
Excel includes a pseudo random number generator that can be used to simulate dice. It is a pseudo random number generator because it is based on a formula and so, is not strictly random, however the numbers generated show many signs of randomness.
Enter the formula =rand() in cell A1
Enter =A1*6 in cell A2.
Enter =floor(a2, 1) in cell a3. This simulates one die.
Copy the cells A1 through A3 across to as many columns as you want. If you want two dice, for example, copy the formulae to cells B1 to B3.
Press F9 to roll dice again. Each time you press F9 you will get new results, but the formula stays the same.
Tips & Warnings
- This updates every time the spreadsheet is changed. That is, if you enter another column, all the other columns will change, simulating another roll of the dice.
- Photo Credit Jupiterimages/Polka Dot/Getty Images
How to Make a Line Graph in Microsoft Excel
In Excel 2013, a line chart is the best option for graphing one or more sets of data across a chart with...