+ Reply to Thread
Results 1 to 4 of 4

Calculating Percentages

  1. #1
    Registered User
    Join Date
    07-15-2015
    Location
    Seattle
    MS-Off Ver
    2007
    Posts
    26

    Calculating Percentages

    Hi Everyone!

    I have a casino dice statistics spreadsheet that calculates the statistics of two dice being thrown.

    I have one cell that calculates the total # of rolls, and then a bunch of other cells that need to use that # to calculate a percentage and insert it.

    Here is the spreadsheet: Attachment 407498

    So for example:

    Column G, Row 9 = The # of expected "1" results.

    If I have 50 Total Rolls, an the expected % is 16.60, the "expected" rolls would be 8.3

    The math: Total Rolls x .1660

    1) How do I insert that math/function to automatically insert it in those columns/rows?

    Thank you!

    - Jennifer
    Last edited by Jennifer2010; 07-15-2015 at 05:43 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,796

    Re: Calculating Percentages

    In (for example) G6:

    =F6*I6 ????

    If correct, copy down

  3. #3
    Registered User
    Join Date
    07-15-2015
    Location
    Seattle
    MS-Off Ver
    2007
    Posts
    26

    Re: Calculating Percentages

    Quote Originally Posted by JohnTopley View Post
    In (for example) G6:

    =F6*I6 ????

    If correct, copy down
    Close! That got me on the right track. Instead of F6 I had to select the Total Rolls column, and that did it for the "# Expected" column (which means it's taking the total number of throws and using the 16.6% to insert the data).

    Thank you!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,796

    Re: Calculating Percentages

    My pleasure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help calculating percentages
    By magnus1 in forum Excel General
    Replies: 3
    Last Post: 07-12-2012, 09:07 PM
  2. calculating percentages
    By zuwanda in forum Excel General
    Replies: 4
    Last Post: 02-07-2012, 10:45 PM
  3. calculating percentages
    By baileybydesign in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 05-28-2010, 10:15 PM
  4. calculating percentages
    By stephen1000 in forum Excel General
    Replies: 2
    Last Post: 03-10-2009, 05:28 AM
  5. [SOLVED] Calculating percentages
    By Louise in forum Excel General
    Replies: 4
    Last Post: 12-09-2005, 12:15 PM
  6. [SOLVED] Calculating percentages
    By Yari in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2005, 03:38 PM
  7. [SOLVED] calculating percentages
    By msdobe in forum Excel General
    Replies: 6
    Last Post: 07-29-2005, 12:05 PM
  8. [SOLVED] Calculating percentages
    By tssjhs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-25-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1