Dice Simulation in Excel

In episode 166 of the Learn Excel from MrExcel podcast, I talked about using the RandBetween function to create a pair of dice in Excel. I quipped that if you wanted to play Monopoly but were missing the dice, this trick would come in handy. The podcast was an improvement on the technique discussed on page 170 of the book Learn Excel from MrExcel.

There is always a better way of doing something in Excel. I received a nice note from viewer Peter Marcaurelle a few days later. He offered up a worksheet that actually had dice that looked liked dice. I've taken Peter's formatting idea and adapted it with my formula.



Read the complete details for both methods in tip119.