Multiplying a cell by one number if another cell is one number or by another if it is another number

[YoungSparky]

What I am trying to do is build a bankroll management spreadsheet.

I want to start with a number say 10,000
My base bet would be 4%
Increase the bet by 1.25% on a win
Decrease it by .25% on a loss


Cell A1 = 4 Cell B2 =1.25 Cell C3 = .25

Cell A4 = 10000
cell A5 = 500 B5:B500 = wins C5:C500 = losses
Cell A6 = A4+B5-C5 Giving the new bankroll number
Cell A6 = would be a formula that multiplies cell A6 by either B2 or C3 depending on if the last bet was a win or a loss.


Any suggestions? I am currently doing most of this by just entering the info myself but I'm trying to automate the process. I have a few other things I want to do as well but I have to figure this one out first as the other issues are similar.


Thanks

 

[etaf]

What do you have in B5 and C2
do you have the text Win and lose?

= A4 + B5 -c5

I would perhaps structure so that just one column has a win/loss - say Column B)
then you could use
In A6
=IF( B5="", "", IF( B5="Loss" , A5* (1-$C$3) , A5*(1+$B$2) ))

 

[YoungSparky]

Thanks. This has gotten me a lot closer to where I want. One more little issue has come up. I want each new bet to increase or decrease depending on a previous win or loss.

ex. Bet 1 4% win, bet 2 5.5% win, bet 3 7% loss, bet 4 6.75% loss, bet 5 6.5% win, bet 6 8% etc....

How would I do this? Thanks in advance for any help.

 

[etaf]

you maybe able to have a table for Loss and Win showing the %

1 Win %
1 Loss %
2 Win %
2 Loss %
3 Win %
3 Loss %
etc
then you could the range for how many wins or loss
and then look up the % for a win or loss

can you provide more detail please
Win1 =4%
Win2 =5.5%
Win3 =6.5%
is this always increasing by 1.5% and is there an upper limit?

BUT you said increase by 1.25% and now it appears to be 1.5%

For loss
Loss1 = 4%
Loss2 = ?
Loss3 = 7% ????
loss4 = 6.75


so could we say 4% + Count how many wins so far and increase by
4% + Countif( range, "Win" ) * 1.25%
4% - countif(range, "loss" ) * 0.25%

perhaps that may work

Can you load the spreadsheet onto a share like, dropbox, onedrive please so we can see some examples
Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.