# Math In Excel does anyone know how to do this

• Aug 15th 2012, 11:02 AM
iBrute
Math In Excel does anyone know how to do this
You are going to roll four twenty-sided dice. If the rolls total to 20 or less, roll two more twenty-sided dice and add that to the total. For instance, if the total of my four die rolls is 32, then that is the score of the game. If the total is 17, then I roll two more dice and add that to the total. If these two bonus dice total 20, then the score of that game is 37. Of ten thousand games, what is the average score?

I am suppose to do this in excel I sortive understand it but i dont know help please
• Aug 15th 2012, 02:10 PM
awkward
Re: Math In Excel does anyone know how to do this
Here's how to simulate the roll of a 20-sided die: enter
=int(1+20*rand())
in cell
A1.

To simulate 4 such dice, enter the same formula in cells A1:D1 (you can do this with copy-paste).

Then enter
=sum(A1:D1)
in cell E1. This is the sum of the four dice.

Maybe you can see from this how to get two more "dice" in cells F1 and G1, and their sum in H1.

I'll leave it to you to figure out how to use an "=if" to put the score of the game in cell I1.

You can then use copy/paste to generate 1000 such games in rows 1-1000 of your spreadsheet. I'll leave it to you to figure out how to get the average.

If you see a smiley above, it's because I entered a colon D and the system helpfully translated it to an icon I did not want. I don't know how to turn that off (he said, not smiling).
• Aug 15th 2012, 02:49 PM
emakarov
Re: Math In Excel does anyone know how to do this
...
Quote:

Originally Posted by awkward
If you see a smiley above, it's because I entered a colon D and the system helpfully translated it to an icon I did not want. I don't know how to turn that off (he said, not smiling).

When you click "Go Advanced," there is a page section called "Additional Options." It has several checkboxes including "Disable smilies in text."
• Aug 15th 2012, 04:09 PM
awkward
Re: Math In Excel does anyone know how to do this
Quote:

Originally Posted by emakarov
...
When you click "Go Advanced," there is a page section called "Additional Options." It has several checkboxes including "Disable smilies in text."

Does that turn the smileys off for me only, or are other readers of the post also affected? I.e., do other readers see a colon D or a smiley?
As a test, here is a colon D
:D

I clicked the "disable smileys", so I see a colon D-- how about you?
• Aug 16th 2012, 02:03 AM
emakarov
Re: Math In Excel does anyone know how to do this
I also see colon D.
• Aug 16th 2012, 03:05 AM
awkward
Re: Math In Excel does anyone know how to do this
Thanks, that indicates the "disable smileys" option affects all readers, not just the writer of the post.