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
Bookmarks