Rand Formula

[Jackie66613]

This is multiple questions. I am working with the RAND formula and a coin toss with multiple simulations to formulate.
A player rolls two six-sided dice 20 times. Each die shows the numbers between 1-6. The dice are "FAIR" meaning that the numbers 1-6 can be rolled with equal probability. If the outcome on both dice is DOUBLES the player wins $5, if it is 7 or 11 they win $3, otherwise they lose $1. I need to put a separate cell for each dice rolled and for the amount they win or lose for 20 rolls. Here is what I have so far
=if(RAND()=Doubles,"Win $5",IF(Rand()=7 or 11, "Win $3, IF(Rand()<7,11,doubles, "Lose $1"))).

[ragulduy]

You could use
=RANDBETWEEN(1,6) to get the number on each dice, so you would need one cell for each dice and then if a1 is dice 1 and b1 is dice 2 you would get
IF(A1=B1,"WIN $5",IF(OR(A1+B1=7,A1+B1=11),"WIN $3","LOSE $1"))

Be careful though because the rand and randbetween formulae will recalculate the number everytime you calculate the worksheet.

[Special-K]

in A1 first die rolled
=INT(RAND()*12)+1
in B1 second die rolled
=INT(RAND()*12)+1

in C1
=IF(A1=B1,"Doubles",IF(OR(A1+B1=7,A1+B1=11),"Win $3","Lose $1"))
in D1
=IF(A1=B1,5,IF(OR(A1+B1=7,A1+B1=11),3,-1))

[Jackie66613]

Thank you, I will try this.

[Jackie66613]

I am sorry I will try and be more specific. Thank you.

[MarvinP]

Hi Jackie,

See the attached for how I think you should do this problem.

[Jackie66613]

Marvin perfect! thank you.