QUOTE (Draco18s @ Feb 11 2010, 04:01 PM) 
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)
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.