Excel Rolling Dice Tutorial

By Ted French, About.com Guide

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.

Return to Overview Page

Previous

• Overview Excel Dice Roller Tutorial
• Building the Dice
• Adding the RANDBETWEEN Function
• The Functions behind the Dots (#1)
• The Functions behind the Dots (#2)
• The Functions behind the Dots (#3)
• The Functions behind the Dots (#4)
• Rolling the Dice
• Hiding the RANDBETWEEN Function

Next