Creating a Pair of Dice (Uses rand(), int(),
or() and if() formulas)
Create the following dice in Excel using formulas. They change value whenever
you press F9.
Steps:
- Adjust the size of the cells to the correct size (Format, Column, Width,
about 3)
- In B5, create a random number between 1 and 6. This will be the 'x' of the
below chart.
- Change the background colour of the die.
- Change the font of the die to be Wingdings. A lower case L in Wingdings is
a dot.
- Create if statements in each of the seven cells to show a dot or not. This
is the formula in A1: =IF(B5>1, "l", " "). Note that a six sided die is
actually a 3 x 3 grid whose pips appear according to the following pattern:
| |
A |
B |
C |
| 1 |
x>1 |
|
x>3 |
| 2 |
x=6 |
x=1 or 3 or 5 |
x=6 |
| 3 |
x>3 |
|
x>1 |
- Replicate the first die in the second spot. How can you do thing without
typing in all of the above data again?
- Press F9 to get the die to "roll".
- Show me when you are finished.
Idea from: www.ecoo.org/e/resources/spreadsheets/index.html