The Functions behind the Dots (#2)
In cells D2 and F2 type the following function:
= IF ( E5 = 6 , " l " , " " )
This function tests to see if the random number in cell E5 is equal to 6. If so, it places an "l" in cells D2 and F23. If not, it leaves the cell blank ("").
To get the same result for the second die, in cells H2 and J2 type the function:
= IF ( I5 = 6 , " l " , " " )
Remember: The letter "l" ( lowercase L ) is a dot in the Wingdings font.