Reply to thread

Message: <blockquote data-quote="ichabod" data-source="post: 1425932" data-attributes="member: 1257">I think this will work:=ROUND(NORMINV(RAND(),3.5,1),0)That should give you a random variable from 1-6 with a bell curve distribution. This will occaisonally give you a 0 or a 7 (about 1% of the time). You could lower this chance by shrininking the 1, but it's always going to be there. Or you can do a two cell formula, with the second cell being:=IF(A1<1,1,IF(A1>6,6,A1))Replacing A1 with whatever cell the first formula is in.What if you want another die? Add one to the number of sides, and divide by two. That number replaces 3.5 in the first formula. Divide the number of sides by six, and replace the 1 with the result. For the standard dice, this gives you:d4: =ROUND(NORMINV(RAND(),2.5,0.66),0)d8: =ROUND(NORMINV(RAND(),4.5,1.33),0)d10: =ROUND(NORMINV(RAND(),5.5,1.66),0)d12: =ROUND(NORMINV(RAND(),6.5,2),0)d20: =ROUND(NORMINV(RAND(),10.5,3.33),0)d100: =ROUND(NORMINV(RAND(),50.5,16.66),0)</blockquote>