dice

  1. S

    Storing Results of a Dice Roll

    Hi Guys Hope this is possible. I have a neat little single dice roll set up, but now that is working, I want to "store" the results of each roll in consecutive cells. So, dice roll 1 scores a 5 store in cell G1 dice roll 2 scores a 3 store in cell G2 dice roll 3 scores a 1...
  2. G

    Parsing and evaluating formulas using "VALUE, "MID", "FIND", nested "IFERROR", and "OFFSET"

    Hello, everyone here. I hope you're all well. I'm posting this thread looking for help with a few formulas that I've been struggling with and making minimal progress. The formulas I'm needing help with deal with dice rolling and randbetween stuff for a pen and paper role-playing game. Here is...
  3. M

    Dice combinations/probability for die with 0 or 1 on each side

    I have four six sided dice with 0 or 1 as result. How do I determine probability of each result. The result totals would be zero - all four dice come up blank. 1, 2, 3, 4. Each die has three blank sides and three sides with a single dot.
  4. DRSteele

    Fun with rolling dice

    I stumbled across this old post http://www.mrexcel.com/tip119.shtml I messed around and found another way to roll some dice. Format A1 and B1 with any font sized 48 and D1 28. Have fun. Dice <tbody> Worksheet Formulas <tbody> Cell Formula A1 =UNICHAR(RANDBETWEEN(0,5)+9856) B1...
  5. M

    Excel solver

    Hello Is there a way to get excel to calculate the closest percent for dice rolls for set percentage for example if you roll 3 6 sided dice here is the percentage for each roll. 3 = 0.46% 4 = 1.38% 5 = 2.77% 6 = 4.62% 7 = 6.92% 8 = 9.72% 9 = 11.57% 10 = 12.50% 11 = 12.50% 12 = 11.57% 13 =...
  6. I

    User defined non-volatile function adding specified number of randbetweens

    Using Windows 7 and Excel 2013. I'm trying to create a function to facilitate table top role-playing (i.e. Dungeons & Dragons). I want the formula to accomplish a randbetween for a specified number of times. I would also like the formula to be non-volatile (i.e. doesn't recalculate every time...
  7. G

    Specific Dice Roll Function

    Hello everyone!I am trying to come up with a function to facilitate a specific random number generation. I want to generate N dice rolls and get the sum of those rolls. N is dependent on the number in another randomly generated cell.I am using the =RANDBETWEEN(1,6) to get a six-sided die roll...
  8. A

    Determine Next Number based on Previous Dice Rolls

    Howdy everyone, I have a general question for anyone who is smart in statistics. For a school project I am wanting to see if I can predict, with a probability percentage, what the next dice roll will be based on previous dice rolls. For example: If with a give two set of dice I roll in this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top