How to calculate a probability of events in excel?

[VVtech]

I would like to run a test 1000 times where there are only two possibilities of the event to occur out of 30 outcomes. Is it possible in excel?
For example: I have 30 numbered stones in a bunch from 1 to 30. How many times I randomly pick stone no1 or 2 when I try this 1000 times?
Is it possible to execute this in excel and get a detailed answer in %? Could someone help me with a formula, please?

 

[mjbeam]

If you put this formula in a cell:

=INT(RAND()*30)+1

...it will give you a random number between 1 and 30. If you put the equation in 1000 cells, it will give you a 1000 numbers between 1 and 30. Count how many times you get a 1 or a 2 and divide that by 1000.

But there is a 1 in 30 chance you will pick a 1. There is a 1 in 15 chance you will pick a 1 or 2. That is about 6.7% of the time.