1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel Rolling Dice Tutorial

By , About.com Guide

3 of 9

Adding the RANDBETWEEN Function

The RANDBETWEEN Function

The RANDBETWEEN Function

© Ted French

Adding the RANDBETWEEN Function

The RANDBETWEEN function is used to generate the random numbers shown on the two dice.

For the first die

  1. Click on cell E5.

  2. Click on the Formulas tab of the ribbon menu.

  3. Choose Math & Trig from the ribbon to open the function drop down list.

  4. Click on RANDBETWEEN in the list to bring up the function's dialog box.

  5. Click on the "Bottom" line in the dialog box.

  6. Type the number 1 (one) on this line.

  7. Click on the "Top" line in the dialog box.

  8. Type the number 6 (six) on this line.

  9. Click OK.

  10. A random number between 1 and 6 should appear in cell E5.

For the second die

  1. Click on cell I5.

  2. Repeat steps 2 to 9 above.

  3. A random number between 1 and 6 should appear in cell I5.

Return to Overview Page

Explore Spreadsheets
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Random Number Functions
  6. Rolling Dice - Create Rolling Dice in Excel

©2009 About.com, a part of The New York Times Company.

All rights reserved.