The Functions behind the Dots (#1)
In cells D1 and F3 type the following function:
= IF ( AND ( E5> = 2 , E5 < = 6 )," l " , " ")
This function tests to see if the random number in cell E5 is between 2 and 6. If so, it places an "l" in cells D1 and F3. If not, it leaves the cells blank ("").
To get the same result for the second die, in cells H1 and J3 type the function:
= IF ( AND ( I5 > = 2 , I5 < = 6 )," l " , " ")
Remember: The letter "l" ( lowercase L ) is a dot in the Wingdings font.