LinkBack URL
About LinkBacks
JBeaucaire 
Yeah, a brute force formula,. No way to do 100 rolls there...but thanks for input.
Yeah, a brute force formula,
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
No 100 wouldn't work. OP asked for 20 and this does 21 actually but to do 100 then you could do this formula in 5 cells and add them which would give the same result.Originally Posted by JBeaucaire
Yeah, a brute force formula,
But ..... If I was doing 100 I think I'd tackle this differently (other than the obvious vba solution) and try to fit a curve to the distribution curve for the roll options between 100 and 600 noting that they have different probabilities. I worked a curve out for three dice rolls but that only has 216 combinations between 3 and 18. 100 rolls has 6^ 100 which is beyond my comprehension. I'd be UDFing this one.
Happy with my advice? Click on the * reputation button below
Me too. The UDF would be remarkably simple. But I was thoroughly intrigued if a single formula could be created to do it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks