Slot machine

Hello!!

I am trying to do a homework of making a slot machine in excel.

I will make 10 tries..so i will have ten rows...

and accordingly i will have 3 columns

my words are "apple" "mango" and "orange"

For each wheel der is 20% probability for apple, 15% for mango and 25% for orange.

how can i simulate de slot machine? should be using rand()??

please suggest

Thanks

Hi
As it is homework I am not going to try and give you the solution. Try searching for a solution on Google. Here is a link to the first one I found with my search:

http://www.freevbcode.com/ShowCode.asp?ID=854

Good luck.
Tony

Hello,

i am trying to write a formula....using vba s out of the scope..

will it be like...generating random numbers and then assigning names according to the probabilities??

Many thanks