Hello All,
Thank you guys for the input on my last question. I got that answer correct.
I have another RAND function that I cannot figure out...this RAND function
is just not my thing. I'll just list the quesetions....it's easier to
understand that way.
#1)There is 1 minute 50 seconds left to go in the championship football game.
Our team is down by 5 points. We recover the ball on the opponent's 45 yard
line. We have no time-outs left and there is enough time on the clock for
exactly 8 plays. Coach figures that on each play these are the probabilities:


20%-gain 7 yards
10%-gain 15 yards
10%-gain 25 yards
10%gain 3 yards
10%-sack, lose 10 yards
10%-interception
28%incomplete. no gain or loss
2%-gain 60 yards
a) simulate the rest of the game. If you cross the goal line you win. If
you don't make it to the goal lne or there is an interception, you lose.
Have a singe cell at the top that givese the result of the game, either win
or lose. Dont worry about the 1st downs
B)Do worry about the 1st downs. If you do four down without a net gain of 10
yards after any down you lose.

I can't figure out the formula to add or subtract the yards successfully
while getting a "win" or "lose" result at the same time. Thanks for your
help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200607/1