Multiple "IF" and "And" formula

[hgh1_us]

Hey Guys,

I am wanting to create a formula as it pertains to the game roulette.

I have a random number simulating a number on the roulette wheel and also a formula to tell me if I won or not, but I need a formula to tell me what to bet based on certain conditions.

Both column D&E will have identical bets based on the last spin below..

1. If I win and the result in column "B" is a "Yes" or Column "C" is a "1" (same thing).. then the bet needs to reduced by $20 for each win, with $10 being the minimum bet for both column D and E.
2. If I lose the the result is a "No" or a "0" respectfully, then the bet needs to be increased by $30 for each lose (for both column D and E)

I'm sure I could figure out the formula for what to do If I win (d6 =d5-20) or if I lose (d6=d5+30), but the addition of the other "if" "and" ($10 minimum bet is making it hard for me).

Thanks so much for your help.. picture is attached.

 

[awoohaw]

try this:

mr excel questions 17.xlsm
	A	B	C	D	E
3	Random #	Win?		bet col1	bet col 2
4	23	Yes		10	10
5	14	Yes		10	10
6	27	Yes		10	10
7	7	No		40	40
8	7	No		70	70
9	20	Yes		50	50
10	22	Yes		30	30
hgh1_us

Cell Formulas
Range	Formula
D4:D10	D4	=IF(B4="Yes",MAX(10,N(D3)-20),D3+30)
E4:E10	E4	=IF(B4="Yes",MAX(10,N(E3)-20),E3+30)

 

[hgh1_us]

try this:

mr excel questions 17.xlsm
	A	B	C	D	E
3	Random #	Win?		bet col1	bet col 2
4	23	Yes		10	10
5	14	Yes		10	10
6	27	Yes		10	10
7	7	No		40	40
8	7	No		70	70
9	20	Yes		50	50
10	22	Yes		30	30
hgh1_us

Cell Formulas
Range	Formula
D4:D10	D4	=IF(B4="Yes",MAX(10,N(D3)-20),D3+30)
E4:E10	E4	=IF(B4="Yes",MAX(10,N(E3)-20),E3+30)

That works perfectly! Thank you so much!!

 

[awoohaw]

My pleasure, and if you think a post here has provided you with a solution, please mark it as the answer.