Game of craps

[ldickson]

I need help with building a formula using IF, AND, OR functions. Can someone help. Thanks!

In a game of craps, on each roll of the dice after the first roll, the rules are as follows: If the game has not ended and the current roll matches the first roll, we win the game. If the game has not ended and the current roll is a 7, we lose. Otherwise, the game continues. Develop a spreadsheet that tells us (given knowledge of the first four rolls) the status of the game after four dice rolls.

[VBA Noob]

See if link helps

http://www.mrexcel.com/tip119.shtml

VBA Noob

[ldickson]

Thanks for the tip...I went to that site but I'm still confused about his solution and formulas.

[VBA Noob]

Maybe this link will help

http://www.excelforum.com/showthread...highlight=dice

VBA Noob

[daddylonglegs]

Who knows the game of craps? How do I create a formula for four rolls.

At the most basic level you can simulate the roll of a die with this formula in any cell

=INT(RAND()*6+1)

which returns a random integer between 1 and 6, so you can simulate the rolling of a pair of dice with that formula in two cells, press F9 and the numbers change, i.e. new roll

[Excelenator]

Anyone for a game of craps?
press F9 to "Roll"

[VBA Noob]

Not bad.

The one on the link is also good


VBA Noob

[Excelenator]

VBA Noob,

Interesting and the formula is RANDBETWEEN(1,6) which is much simpler than =INT(RAND()*6+1)!

[VBA Noob]

I like the way to call the dot

=IF(A2>1,CHAR(108),"")

cell formatted as Wingdings

The Randbetween needs the Analysis ToolPak add-in installed


VBA Noob