1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Rolling Dice Tutorial

By

4 of 9

The Functions behind the Dots (#1)
Excel Dice Roller Tutorial

Excel Dice Roller Tutorial

© Ted French

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.

Return to Overview Page

©2014 About.com. All rights reserved.