Losing dice because of unknown factors, Unelegent rules? Options

[Smokeskin]

Use this in cell C3, which would be your 0 dice, 0 hits cell.
Copy and paste for all other cells.
=BINOMDIST($A3,C$1,1/3,TRUE)*60

Will return an error in cells where you're asking for more hits than dice.


Use this in cell C2, which is your glitch row
=BINOMDIST($A3,C$1,1/3,TRUE)*60

Cell C3 will return an error (there are no dice, so 1/2 of them can't come up ones), but you can copy it horizontally.


It however looks like you'll never get more than 6 hits on 9 dice unless you start counting fractional seconds (60 > 59.5 -> 6 hits, 7 hits would need 59.94 and 8 would need 59.99)

Thanks for getting the proper English function names - I can see you use different argument separators too.

I don't think it is necessary to distinguish that many hits for secret rolls, but if it is, you can just roll the remaining dice. Ie ff you roll 9 dice and get 60, the table says that that is at least 6 hits, but we can't distinguish what the last 3 dice are. So you could just roll 3 more dice and add the hits to the 6 you already have.