Results 1 to 6 of 6
Like Tree2Thanks
  • 1 Post By emakarov
  • 1 Post By emakarov

Math Help - Math In Excel does anyone know how to do this

  1. #1
    Newbie
    Joined
    May 2012
    From
    alabama
    Posts
    17

    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
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Super Member
    Joined
    Mar 2008
    Posts
    934
    Thanks
    33
    Awards
    1

    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 A11 (you can do this with copy-paste).

    Then enter
    =sum(A11)
    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).
    Follow Math Help Forum on Facebook and Google+

  3. #3
    MHF Contributor
    Joined
    Oct 2009
    Posts
    5,536
    Thanks
    778

    Re: Math In Excel does anyone know how to do this

    ...
    Quote Originally Posted by awkward View Post
    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."
    Thanks from awkward
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Super Member
    Joined
    Mar 2008
    Posts
    934
    Thanks
    33
    Awards
    1

    Re: Math In Excel does anyone know how to do this

    Quote Originally Posted by emakarov View Post
    ...
    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?
    Follow Math Help Forum on Facebook and Google+

  5. #5
    MHF Contributor
    Joined
    Oct 2009
    Posts
    5,536
    Thanks
    778

    Re: Math In Excel does anyone know how to do this

    I also see colon D.
    Thanks from awkward
    Follow Math Help Forum on Facebook and Google+

  6. #6
    Super Member
    Joined
    Mar 2008
    Posts
    934
    Thanks
    33
    Awards
    1

    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.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. help in excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: May 26th 2011, 05:29 AM
  2. excel
    Posted in the Math Software Forum
    Replies: 8
    Last Post: April 23rd 2008, 07:48 AM
  3. excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: January 21st 2008, 05:24 AM
  4. Business Math Help MS Excel
    Posted in the Business Math Forum
    Replies: 2
    Last Post: November 8th 2007, 11:13 PM
  5. Excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: August 13th 2007, 05:26 PM

Search Tags


/mathhelpforum @mathhelpforum