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 Create Multiple Formulas for the Same Space in Excel
Microsoft Excel is a versatile program that allows for quick data entry into its columnar grid of cells. Once data is input,...
How to Make a Line Graph in Microsoft Excel
Microsoft Excel makes it easy to make a line graph. All you need to do is supply the data for the line...
How to Do Excel Formulas
Formulas are an excellent way to maximize your efficiency when working with Excel. Excel has built-in formulas for finance, basic math, statistics,...