hey been working on this forever and can't seem to get it...

Simulate the profit of the race. Assume the number of spectator is affected by the weather. Probability distribution of weather is as follows:
Weather Probability
Clear .5
Cloudy .3
Rain .2
 If weather is clear, the number of spectator would be 1,500.
 If weather is cloudy, the number of spectator would be 1,000.
 If weather is rain, the number of spectator would be 300.
How do I do this in excel?
I already have a profit model/chart everything but I don't know much about simulations and probablity stuff..thanks