How to Make a Dice Roller in Excel

Save

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.

References

  • Photo Credit Jupiterimages/Polka Dot/Getty Images
Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!