Probability Question:talent competition

Thanks for this Marvin. I'm sure you are right about it being a binomial distibution formula but I too am unsure of how to use the binomial function in this situation.

I understand what has been done here by using the random formula against each act and I guess this would work well. It is also an interesting to simulate the number of yes votes.

Can I just check the VBA code is correct though? I have had a look at the code and although I can't say I completely understand it, I have managed to change the number of loops to just one rather than 1,000 to test it and it doesn't seem to work how I understand it should.

The way I understand it is when you press the button the worksheet does a calculate and 1 is added to the count in the table B10:C17 corresponding to the count in cell G8.